| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change font colour for values. eg if value < 10 red, gre.
trying to get font to change when values are above or below set amounts.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change font colour for values. eg if value < 10 red, gre.
Use conditional formatting. Look it up in help or post back with specific
requirements. Regards, Fred. "Chris" wrote in message ... trying to get font to change when values are above or below set amounts. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change font colour for values. eg if value < 10 red, gre.
Go into help and look up Conditional Formatting. HTH Otto
"Chris" wrote in message ... trying to get font to change when values are above or below set amounts. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change font colour for values. eg if value < 10 red,
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. "Fred Smith" wrote: Use conditional formatting. Look it up in help or post back with specific requirements. Regards, Fred. "Chris" wrote in message ... trying to get font to change when values are above or below set amounts. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change font colour for values. eg if value < 10 red,
Select the cell with the formula.
FormatCF Condition 1Cell Value is: Check Tank Volume Condition 2Cell Value is: Tank Volumes OK Gord Dibben MS Excel MVP On Sun, 30 Aug 2009 11:36:01 -0700, Chris wrote: 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. "Fred Smith" wrote: Use conditional formatting. Look it up in help or post back with specific requirements. Regards, Fred. "Chris" wrote in message ... trying to get font to change when values are above or below set amounts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font colour | Excel Discussion (Misc queries) | |||
| FONT COLOUR CHANGE | Excel Worksheet Functions | |||
| Change font colour | Excel Discussion (Misc queries) | |||
| Change font colour | Excel Discussion (Misc queries) | |||
| Change font colour for whole row | Excel Worksheet Functions | |||
Linear Mode
