A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
conditional formatting with "" cell
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.