Thread: Incorporating Cell color fill in an "if" logical function?
View Single Post
  #35   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Son of a Sea Cook Son of a Sea Cook is offline
external usenet poster
  
Posts: 3
Default Incorporating Cell color fill in an "if" logical function?
On Sun, 30 Aug 2009 20:52:01 -0700, Josh
wrote:

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?

You can let the internal engine do it.
Reply With QuoteReply With Quote