I have a column with dates in them and want to change the color of the cells when they reach a certain date. I set up the formatting so that it changes if the cell value is less than or equal to todays date (referencing =Today() in a seperate cell. This works fine, but it also formats any blank cells. How can I set it up so that the formatting only occurs in the cells with values? I highlighted the entire column when I set up the conditional formatting so that I wouldn't have to keep adding it as I added rows of data.
Thanks.
Thanks.