View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MKLeisure
 
Posts: n/a
Default How do I change the font color based on results of an IF stateme

In an Excel Work sheet I want to examine the contents if the Division column
and if the division is HR change the Font color to red else leave the font
color black. AS an example. IF F2 = "HR", change the text in F@ to red,
change it to black.