Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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.

Re: Condional formatting based on value of another cell?

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


Re: Condional formatting based on value of another cell?

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


Re: Condional formatting based on value of another cell?

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

===========


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.