Help ....! Conditional Formating

  • Thread starter Thread starter housinglad
  • Start date Start date
H

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
 
housinglad said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Help 2
Tweaking formula? 2
Help with formula? 4
help with formula 5
Still need help with formula 8
Help with formula? 1
Help with formula 4
more help on INT, MOD 3

Back
Top