<div>
Use the formula, rather than the cell value as the condition<br />
Example: &nbsp;Put the following conditional formatting formula for cell A1<br />

<pre><code id="code-20-40250105-1">=C1=&quot;Active&quot;</code></pre>
Then set the interior cell color and click OK
</div>


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


=C1="Active"

Then set the interior cell color and click OK

<div>
Hi frugalmule,<br />
<br />
How did you get on with this?<br />
<br />
tel2
</div>


Hi frugalmule,

How did you get on with this?

tel2

<div>
I'll assume that means: &quot;it worked&quot;.<br />
Thanks for the points!
</div>


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

<div>
@frugalmule<br />
<br />
Why wasn't my comment accepted as the solution? &nbsp;It was posted prior to the accepted comment.
</div>


@frugalmule

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

<div>
<div class="content wysiwyg-content">
Here is a video description <a href="http://screencast.com/t/4j8nbl5o6O" rel="ugc">http://screencast.com/t/4j8nbl5o6O</a>.
</div>
</div>


Here is a video description http://screencast.com/t/4j8nbl5o6O.

Highlight background in column A based on contents in column C

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.