Format a blank cell based on the value of another cell
In the Conditional Formatting dialog of B2, select "Formula Is" in the drop
down and use this formula...
=A2="X"
Click the Format button and select whatever formatting you want.
Rick
"tracktor" wrote in message
...
I want to change the format of a blank cell (B2) when the value in another
cell (A2) equals X. I have tried to use conditioanal formating, but
there
is a formula in cell A2 that creates the value X, and I cant seem to
get
the right info into the conditional formatting in cell B2.
I have been able to accomplish this by creating conditional formatting in
cells A2, B1, C2, and B3 by putting a boarder adjacent to cell B2 based on
formulas I have created in eache of those cells, esentially putting a
boarder
around cell B2. But I know there is an better, cleaner, and easier way.
|