I love conditional formatting. Two advanced user tips:
1) Watch out for fixed cell references:
When you choose another cell (say a4) to compare your cell to (say b4), Excel puts dollar signs in so that if you copy this format to another cell (say a5) it compares to $a$4, rather than the cell that is in the same relative position as the first cell (which would be b5 in this example.) This may be exactly what you want, but if it is not, you will have to edit the $s out of the condititional formatting before copying.
2) If you want your conditional formatting to have nothing to do with the value in the cell, but instead to be based on the value in another cell (a4), set up an intermediate cell (b4) that uses a formula like this:
=if(a4={condition},{a number that is guaranteed to be higher than the number in the formatted cell}, {a number that is guaranteed to be lower than the number in the formatted cell})
Then have your conditional formatting do a greater than or less than comparison to the intermediate cell.
