Conditional Formatting

  • Thread starter Thread starter Michelle B.
  • Start date Start date
M

Michelle B.

I am attempting to use the conditional formatting to color
code some cells, I want to say,
If C1 = 0 then highlight A1 in red, how would I do that.

Thanks

Michelle
 
1st: select "Formula Is" instead of "Cell Value Is" in
the left dropdown. The rest of the line changes to one
long textbox. Enter "=$C$1=0" (no quotes) then select
your format style from "format" button and "color"
dropdown. that should do it.
 
Michelle, select A1 and conditional format as formula is =C1=0
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top