Highlight Cells

cpatte7372
cpatte7372 used Ask the Experts™
on
Hello Experts,

While waiting for assistance with another issue concerning Excel Timer Alert, I was wondering if someone could please show me how to write a formula to highlight cells.

In attachment I would like a different highlight for cells with AP3, AU3, AQ3 and AV3.

Cheers

Carlton
EE-ABC-1700.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011
Commented:
You cannot do this with a formula, but you can use conditional formatting.  On the 'Home' tab, under styles you'll see Conditional formatting...  Select your cells, choose Highlight cells rules, then Equal to, and set the formatting you want.

Author

Commented:
Hi andrewssd3,

I should've thought of that.

Cheers mate.
Top Expert 2011

Commented:
I don't want to seem grasping here, but if you liked this solution and the one to your other Excel run-time error 13, please could you give me the points?  Wife and 4 hungry children to support...

Author

Commented:
Hi Andrew,

Sorry for delay in awarding points

Cheers mate

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