Conditional Formatting Rows After Data Issue

[geospatial]

I have conditional formatting set to look at all of J Column as our data could expand. In the formatting it will set the cell to red if the cell value is less than or equal to TODAY().

The only issue I have is that it continues down after the last row of data. How can I fix this?

I am using Excel 2013.

 

[markmzz]

I have conditional formatting set to look at all of J Column as our data could expand. In the formatting it will set the cell to red if the cell value is less than or equal to TODAY().

The only issue I have is that it continues down after the last row of data. How can I fix this?

I am using Excel 2013.

Hi!

Try this:

=($J1 <> "")*($J1 <= TODAY())

Markmzz

 

[geospatial]

That worked great. Thank you

 

[markmzz]

That worked great. Thank you

You are welcome and thanks for the feedback.

Markmzz