Conditional Formating
 

I am trying to use conditional formating to format a cell if another cell
has a value in it less than 11. I tried using the formula test with an if
statement to test other cell value, but it appears this is not a way to do
this. Does anyone know how this can be done. thanks.

Hi Jon,

Try this:

If you format the range [A2:A10] then:

1) select the range [A2:A10] (make sure [A2] remains active)
2) go to menu FormatConditional Formatting
3) In condition 1 choose 'Formula is' from the 1st dropdown
4) put the following formula into the formula box: =B2=11
5) presss the Format button and select your prefered formats
6) press OK,OK
7) try entering 11 into any cell in the range [B2:B10]


Regards,
KL


"Jon Ottman" wrote in message
. verio.net...
I am trying to use conditional formating to format a cell if another cell
has a value in it less than 11. I tried using the formula test with an if
statement to test other cell value, but it appears this is not a way to do
this. Does anyone know how this can be done. thanks.

Try this

=$A$1=11


"Jon Ottman" wrote in message
. verio.net...
I am trying to use conditional formating to format a cell if another cell
has a value in it less than 11. I tried using the formula test with an if
statement to test other cell value, but it appears this is not a way to do
this. Does anyone know how this can be done. thanks.