We help IT Professionals succeed at work.

Highlight background in column A based on contents in column C

195 Views
Last Modified: 2015-03-02
Here is a video description http://screencast.com/t/4j8nbl5o6O.
Comment
Watch Question

aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
Use the formula, rather than the cell value as the condition
Example:  Put the following conditional formatting formula for cell A1
=C1="Active"

Open in new window

Then set the interior cell color and click OK
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
Hi frugalmule,

How did you get on with this?

tel2
CERTIFIED EXPERT

Commented:
I'll assume that means: "it worked".
Thanks for the points!
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
@frugalmule

Why wasn't my comment accepted as the solution?  It was posted prior to the accepted comment.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.