Excel Conditional Formatting Dates Office 2016 Mac

[r0cketbev]

Hi All,

 

I am a idiot when it comes to Excel. I want to highlight a date before 4/7/2018. I can get it so it gives me that date and above but not below. How do I do it?

 

Cheers

 

RB

[Strawdog]

Hi RB,

 

Conditional Formatting -> Add rule -> Style = Classic -> Use formula to determine which cells to format

 

=A1:A6

 

A1:A6 = Adjust these for the range within which you want to highlight cells

Date within the formula is in the format Year, Month, Day

[r0cketbev]

@Strawdog you are a star