Conditional Formatting--Formula is

The other choice with conditional formatting is "Formula is." It's a lot more dynamic than the "Cell Value is" option.

With this, you can format one cell based on the value in an entirely different cell. In fact, you can change the format of a whole row of cells based on the value of one value in that row.

Once you have created this conditional formatting, copy and paste as formatting only along the rest of the row. You'll get results like this:

Well, this is great, of course. But, if you had to do this for even 10 rows of data, you would be doing way too much work. Look again at this:
See the $F$2? The dollar signs mean that whenever you copy and paste the conditional formatting, it will always look to F2 to see if it's greater than 52000. If you want it to always look at column F, but you want it to look at the value on each row, type the formula like this:=$F2>52000. (Little tip for you keyboarders like me...don't use your arrow keys. I don't know what Excel is trying to do, but it starts changing things and is not helpful at all! Use your mouse to move around in the formula box.) Now, each cell where you have pasted this format has conditional formatting. It will always look to the value in F, and apply the formatting when it meets the defined condition. See below:


PASTING SPECIAL:
Using paste special is easy once you know how. Here's how.
After copying, right click where you want to paste the data-->Choose Paste Special. It will bring up this menu:

Now, choose formats.

Very handy, eh?

There are no less than two other ways to do this. You can also choose Edit-->Paste Special. Or, even more fun, choose View-->Toolbars-->Customize to get this menu:


Left Click and drag the Paste Formatting icon to your tool bar. While you're at it, pull the Paste Values icon up there, too. You know, scroll down to the bottom and grap the Select Visible Cells and drag that one up, too. It will come in handy later. Now that the two most often used paste special buttons are on your toolbar, use these whenever you want to perform one of these special pasting tasks.