Thread: Incorporating Cell color fill in an "if" logical function?
View Single Post
  #34   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Josh is offline
external usenet poster
  
Posts: 103
Default Incorporating Cell color fill in an "if" logical function?
I am trying to shade the row if a particular cell in the row has a date value
in one of three categories. What I have done is not working. Statements are
below.

="If(($B$2-NOW)=30)"
="if(($B$2-NOW)<0)"
="If(($B$2-NOW)<=30)"

It is not coloring a single cell.Any ideas of better logic to use?
Reply With QuoteReply With Quote