Thread: Change the color of a cell or text with an if statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Oddcarout Oddcarout is offline
external usenet poster
  
Posts: 6
Default Change the color of a cell or text with an if statement
=IF(D6="Yes", "Complete", IF(F6=$B$1, "Current", "Past Due"))

I want it to be red if "Past Due"

for the conditional I have Formula is ="Past Due"

but that does not work.

thanks
Reply With QuoteReply With Quote