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
===========
