Help ....! Conditional Formating

[housinglad]

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

 

[Victor Delta]

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