Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change font colour in an if command?
How do I change font colour in an if command?
E.g IF(A1=10, "OK", "NOT OK"{I want to display this text in another colour to stand out}) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change font colour in an if command?
You would have to do this with Conditional Formatting (from the Format
menu). Select the cell then Format | Conditional Formatting and in the panel Cell Contents type "NOT OK" then click the Format button and choose your font/colour/effect and background colour (patterns tab), then OK your way out. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
font colour won't change in Excel 2003 | Excel Discussion (Misc queries) | |||
Change cell colour by date | New Users to Excel | |||
Change the Row Colour, using a cell condition | Excel Discussion (Misc queries) | |||
Quick Text colour change? | Excel Discussion (Misc queries) | |||
how do i change the font size in a combo box? | Excel Worksheet Functions |