We help IT Professionals succeed at work.

Excel Conditional Formatting

How do I write a conditional format in Excel, that turns any cell containing a date that falls in the month of Jul, Aug, Sep, Oct, Nov Or Dec blue? Thanks!
Comment
Watch Question

Hi,

Use this formula =MONTH($A2)>6
see the attached pics for illustration.

Br,
Abbas Abdulla
CF-Step-1.PNG
CF-Result.PNG
Cactus1993Owner

Author

Commented:
Great! Thank you!