Excel Excel Conditional Formatting help needed.


Joined
Aug 20, 2015
Messages
1
Reaction score
0
Hi All

I have read lots of Help tutorials on conditional formatting but still cant find what i am looking for.

This is what i am trying to do.

i have 4 rows with a range of cell that i want to get to highlight in a colour if the dates are less than 3 months.
I know one of the ways is to highlight the Selected Cells and then click on Conditional Formatting and you can select highlight cell rules and select the less than rule.and type in =TODAY()+90 it does that which is what i need it to do. but i don't want it to highlight blank cells.

i have attached an example of what i am trying to do with what i have done.

Is there anyway to do this? or is there another way to go about please feel free to advise on which ever way it can be done.

Thank you for your assistance, its greatly appreciated.
 

Attachments

  • Conditional formatting for Expiry Dates.pdf
    214.9 KB · Views: 149
Ad

Advertisements

Joined
Feb 18, 2015
Messages
6
Reaction score
0
You need to add a second rule where you do a Formula rule for Blank cells.
See the attached for details.
 

Attachments

  • ConditionalFormat_Issue.pdf
    173.4 KB · Views: 134

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top