[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Highlight background in column A based on contents in column C

Posted on 2014-08-08
Medium Priority
Last Modified: 2015-03-02
Here is a video description http://screencast.com/t/4j8nbl5o6O.
Question by:frugalmule
  • 3
  • 2
LVL 46

Expert Comment

ID: 40250105
Use the formula, rather than the cell value as the condition
Example:  Put the following conditional formatting formula for cell A1

Open in new window

Then set the interior cell color and click OK
LVL 12

Accepted Solution

tel2 earned 2000 total points
ID: 40250113
Hi frugalmule,

Nice video.  A picture's with a thousand words.

Change the "Text Contains" to "Custom formula is", which should be at the bottom of the dropdown list.  If it is not at the bottom of the dropdown list, create a new spreadsheet and check if it's there, coz it's only in reasonably recently created spreadsheets, I think.

1. Select the cells in column A, that you want the formatting to apply to.
2. Go into Format > Conditional Formatting
3. Select "Custom formula is" (instead of "Text Contains")
4. Enter this formula: =C2="Active"
5. Select the colour you want.
6. Click "Save rules"

Let us know how you get on.
LVL 12

Expert Comment

ID: 40254806
Hi frugalmule,

How did you get on with this?

LVL 12

Expert Comment

ID: 40262031
I'll assume that means: "it worked".
Thanks for the points!
LVL 46

Expert Comment

ID: 40262186

Why wasn't my comment accepted as the solution?  It was posted prior to the accepted comment.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question