Avoiding formatting in blank cells

Question

this is my first post and a newb at Excel.

I did a few date formulas with conditional formatting and realised after that the formatting is being applied to all the blanks cells as well.

Is there an easy edit I can add to the existing formulas i wrote or do I have to start again?

Formulas below :

=AND($D2>TODAY(),$D2-TODAY()<=7)

=$D2<TODAY()

=$D2=TODAY()

How do I add that in my formulas ? Using AND like this =AND($D2>TODAY(),$D2-TODAY()<=7,$D2<>"") let me try — Rakshitha
– Rakshitha, Commented Aug 1, 2022 at 10:14
Something like =IF($D2<>"",AND($D2>TODAY(),$D2-TODAY()<=7),FALSE). — Harun24hr
– Harun24hr, Commented Aug 1, 2022 at 10:16

Harun24hr · Accepted Answer · 2022-08-01 10:36:25Z

1

Use IF() function to detect either it empty or not. Then apply formula if it is not empty. By default excel empty/blank cell is determine as 0 zero when you are comparing with number values. Dates are nothing but number value. So, to avoiding blank cells in conditional formatting use IF() function like-

=IF($D2<>"",AND($D2>TODAY(),$D2-TODAY()<=7),FALSE)

answered Aug 1, 2022 at 10:36

Harun24hr

38.1k6 gold badges24 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Avoiding formatting in blank cells

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related