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}) |
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 |
All times are GMT +1. The time now is 09:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com