Share via

conditional formatting with "" cell

Anonymous
2012-10-23T14:53:43+00:00

Hello,

How to change formula(s) to conditional format when D3's formula returns " " (date)

G$1 is scroll bar

This works for formatting D3 - E3 if both have date.  Need to add ??? so it will format C3 to E3 if D3 is empty

=IF($D3="","",AND($D3=G$1,$D3=G$1))

=IF($E3="","",AND($D3<=G$1,$E3>=G$1))

=IF($D3="","",AND($E3=G$1,$E3=G$1))

Formatting

C3 - D3 blue

D3 - E3 green

C3 - E3 green if D3 is empty

E3 - F3 brown

This works for formatting C3 - D3 if both have dates and if D3 is empty (formats C3 only)

=IF($D3="","",AND($C3<=G$1,$D3>=G$1))

=IF($C3="","",AND($C3=G$1,$C3=G$1))

This works for formatting E3 - F3 if both have dates and if F3 is empty (formats E3 only)

=IF($E3="","",AND($F3=G$1,$F3=G$1))

=IF($F3="","",AND($E3<=G$1,$F3>=G$1))

=IF($E3="","",AND($E3=G$1,$E3=G$1))

Thanks for your help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments