MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Condional formatting based on value of another cell?


Posted by Rick M on August 07, 2001 6:58 AM

Cell M1 has an if statement that If(h1>0,then L1*.5,L1*.34)
Can I change the text color to red if the statement is true to highlight that L1 is greater than 0?
Thanks.


Posted by Aladin Akyurek on August 07, 2001 7:04 AM

Rick

I'm confused. Which one?

H1>0 ---> the value of M1 becomes red or value of L1 red?
M1>0 ---> the value of M1 becomes red or value of L1 red?

Aladin

Posted by Rick M on August 07, 2001 7:41 AM

I want cell if H1>0 ---> the value of M1 becomes red
Thanks RICK

Posted by Aladin Akyurek on August 07, 2001 7:52 AM

Activate M1.
Activate Format|Conditional Formatting.
Select Formula Is on the Conditional formatting dialog.
Enter as formula: =H1>0
Activate Format.
Select Red via Color.
Click OK.

Aladin

===========