View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Conditional Formatting: Question

try

Formula Is =AND(ISNUMBER($A1), $B1="", TODAY()-$A1=10)


"VegasSageV" wrote:

I need to figure out how to do the following:

Conditional formatting (I know how to define the formatting, just not
the conditions) in B1.

If a1 has a date in it, and b1 is empty, and 10 days or more have
passed since A1.....format with the identified format.

You geniuses are BEYOND awesome!