how to change font colour for values. eg if value < 10 red, > gre.

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

trying to get font to change when values are above or below set amounts.
 
Use conditional formatting. Look it up in help or post back with specific
requirements.

Regards,
Fred.
 
Formula is. =if(d7="","",if($q$5-d7>=46.5,Check Tank
Volumes",if($q$5-d7<=46.5,"Tank Volumes OK"))) . I need to show "Check Tank
volumes" in red and "TankVolumes OK" in green.
Regards
Chris.
 
Select the cell with the formula.

Format>CF

Condition 1>Cell Value is: Check Tank Volume

Condition 2>Cell Value is: Tank Volumes OK


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing font colour to red & orange 1
Question about conditional formatting of zeros in Excel 0
time = say 05:00, how do I change font colours at 15 minute incrim 1
how do I start a macro using If Then statments 2
Insert text depending on font colour 2
Conditional Formatting 2
Conditional formatting with vba 3
Text format - setting text colour with code 5

Back
Top