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.