Multiple Conditional Formatting for Same Data

[tjverdugo85]

For my set of data (N6:AI1048576), I have applied multiple conditional formatting. It is for reporting dates.

So far, I have been able to:

• Highlight dates where reports are overdue.
• Highlight cells which contain "Submitted", "Accepted", and "N/A" (Those three selections are in a drop down I applied to the data, which is also editable so I could type in dates).

I am stuck on how to highlight dates when reports are due 0-30 days from today. I've tried multiple formulas, but nothing seems to be sticking.

 

[Joe4]

Welcome to the Board!

You will need to use the "Use a formula to determine which cells to format" option, and write a condition like:

=AND(N6-TODAY()>=0,N6-TODAY()<=30)

to check to see if the value in cell N6 is between 0 and 30 days from today (in the future).

 

[tjverdugo85]

Welcome to the Board!

You will need to use the "Use a formula to determine which cells to format" option, and write a condition like:

=AND(N6-TODAY()>=0,N6-TODAY()<=30)

to check to see if the value in cell N6 is between 0 and 30 days from today (in the future).

Hello,

Thank you for the reply. I have tried this formula before and it works somewhat, but I only want it to highlight dates, and not all values (dates and text).

 

[tjverdugo85]

Hello,

Thank you for the reply. I have tried this formula before and it works somewhat, but I only want it to highlight dates, and not all values (dates and text). View attachment 103175

Never mind. It seemed to work for me completely this time.