Even though you have completed your task with Norman's
example. I want to make sure that you understand exactly
what you are doing, so that you don't end up with an impression
that sometimes C.F. does exactly what you want and other times
it doesn't. So keep the following statement in mind.
Which cells can be get coloring is based on the selection. The formula
itself is based on the active cell. Each cell in the selection will be tested
and uses 1 of the 3 conditions per cell that you are allowed in C.F.
So select Column B as the cells to be colored
format, conditional formatting, Cell B1 being the active cell.
C.F formula 1: =$A1>10
In Conditional Formatting errors show up as False, so no need
to be concerned about empty cells or your heading titles that
are not numbers.
Since A1 is coded with an absolute Column you could logically
use that formula on any cell on the row. You could actually but
that formula into any empty column to see the True or False values.
More information on Conditional Formatting in
http://www.mvps.org/dmcritchie/excel/excel.htm
You can use the format painter to copy normal cell formatting and
conditional cell formatting. But keep in mind that formatting an
entire column is more efficient than formatting one cell at a time
with separate formats.
