Conditional Formatting

[ashani]

Hi
i would like a conditional formatting on cell A2 - there is a date and I want it to turn Red if it exceeds 7 days from the date in A1 i.e. if 01/05/2020 and if A2 date is 09/05/2020 or higher than cell turn red.

Thank you

 

[etaf]

us a conditional format rule
=A1+7 < = A2

 

[ashani]

hi Etaf,

Thank you for your reply.

How can i stop conditional formatting if A2 is blank. For example i'm using icon but when there is nothing in A2 it's still showing as Tick mark.

 

[pedro-egoli]

Change rule to

=IF(2="","",A1+7<=A2)

 

[etaf]

you could also use an AND()
=AND( A2<>"", A1+7 < = A2 )

 

[ashani]

Hi guys
thank you for your reply and help.
I'm using the below formula currently - so if 0 then X icon and if 1 then tick Icon. How can I put it so if the cell A2 is blank than no Icon.
Currently, where it's blank - it's still showing as 1 means Tick there.

=IF(A1+8<=A2,0,1)

Thank you

 

[ashani]

anyone please guide me on this.
so its icon set in conditional formatting
1 = tick
2 = cross
and if blank = exclamation mark

that's what I'm looking to achieve.