Formula for Conditional Formatting a Row when a Cell Contains a Date

[Denny57]

Hi

My intention is to have five conditional formatting rules, 4 based on Column I text values and 1 with the date format in column J (or where column J is not blank)

I have created 4 rules based on different text values in column I and have applied the "Stop If True" rule, which work fine.

Example =$I4="Preserved" [FORMAT] Applies to =$A$4:$AH$6500:

I now need to apply an additional rule that will apply formatting to the remaining rows which are not highlighted AND where Column J contains either a date value (date format is dd/mm/yyyy) or is not blank. I have tried a number of options from internet searches, including "BLANK" or "NOT BLANK" all without success.

Hopefully the formula will look like this
=$J4= [Date Format or Not Blank] [FORMAT] Applies to =$A$4:$AH$6500:

Thanks in advance

 

[Fluff]

How about using

=$J4<>""

 

[Denny57]

How about using

=$J4<>""

Thanks This works fine

I just tried that without success, however is seems Excel added ""

 

[Fluff]

You're welcome & thanks for the feedback.

Excel will add the quotes if you don't start the formula with =