Help ....! Conditional Formating
 

Hi I need help with the following:

In cell B16 is a valid date. If there is no value in cell B27 (10 working
days in front of the date stated in B16) then I want the dell to go red. If
there is no value in B16 then the script should do nothing.

Thanks
Dan

Help ....! Conditional Formating
 

"housinglad" wrote in message
...
Hi I need help with the following:

In cell B16 is a valid date. If there is no value in cell B27 (10 working
days in front of the date stated in B16) then I want the dell to go red.
If
there is no value in B16 then the script should do nothing.

Dan

Try something like
=and(isnumber(b16),isblank(b27),b27=<b16+10)
as the conditional formatting formula for a red 'pattern'.
Hope this helps,

V