Excel Conditional Formatting

Cactus1993
Cactus1993 used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial