Very simple (you know how, and I dont)

[Stretlow]

I have a simple formula =E4+10 where the value in E4 is a date and populates F4 with 10 days after.... easy.




If the value in E is blank then F will say 10-jan i need this to be blank without using conditional formatting.


Ive used 3 conditional formatting conditions already.

is this possible?

 

[lenze]

For your CF
Condtion 1
Formua IS

=(TODAY()>=$F3)*(TODAY(<$H3)*($F3<>"")*($H3<>"")

Condition 2
Formula IS

=(TODAY()>= $H3)*($H3<>"")

lenze

 

[Stretlow]

For your CF
Condtion 1
Formua IS

=(TODAY()>=$F3)*(TODAY(<$H3)*($F3<>"")*($H3<>"")

Condition 2
Formula IS

=(TODAY()>= $H3)*($H3<>"")

lenze

Hi Lenze, thanks again for your help..

Unfortunately the condition 1 code brings an error and condition 2, whilst accepting the formula is not highlighting the row (i have a date of 11-mar in column h

 

[lenze]

Except for the typo in Condition1,(should be)

=(TODAY()>=$F3)*(TODAY()<$H3)*($F3<>"")*($H3<>"")

the CF works fine. How are you implementing it?
lenze