Conditional Formatting: Question
 

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!

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!

Conditional Formatting: Question
 

thank you so much.