How do I set the colour of a cell depending on a value in another cell?


Posted by chx on December 21, 2000 1:27 PM

Hi,

When I type an "x" in a cell I want the entire row to be filled red. How do I do that?

Posted by lenze on December 21, 2000 1:43 PM

Use the "formula is" option under Format, Conditional Formatting

i.e =C3=4 will set the condition to format the cell you want coloredif the value in C3 is equal to 4. You may also use greater or less than. for the condition



Posted by gdoran on December 26, 2000 2:39 AM


:i.e I tried to use the conditional formatting suggested but it did not work. Is there other steps that must be done to make this work as per the original question?