Thread: How do I change font colour in an if command?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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 With QuoteReply With Quote