Conditional Formatting for Non Blank Cells based on Date less than 30 days from Now

gI have been trying to have certain cells highlighted with two criteria. The first criteria is that the date is within 30 days from today (which I believe would be “cell value < Now()+30”). I have done this using the ‘format only cells that contain’ option. However, it is also highlighting the cells that are blank. How do I limit the first criteria to formatting only cells that are nonblank? I am using Excel 2016.

By: Ashleigh

Leave a Reply

Your email address will not be published. Required fields are marked *