Conditional Format a column

Question

Above yellow formatting has been made manually. How can I do it automatically? Condition is if row 3 is TRUE then format C7:C17 yellow. I guess it should be so simple but none the less I havent been able to get it to work.

Answer 1

(see screenshot above).

Select the cells you want to format and in CF use this formula:

=C$3:N$3 = TRUE

select the color you want to give to cells that meet the criteria to be TRUE.

Hope this helps.

Answer 2

Thank you.

If I type ==TRUE in the formula field (in Conditional Formatting) I get an error (problem with this formula). If instead I enter =C$3=TRUE (and follow your other steps) nothing happens.

Pardon me but I am a bit confused.

Answer 3

Hi,

Yeah, you're right. This thing should be pretty straightforward. We can fix it with conditional formatting in Excel, just using a simple formula.

The goal here is to highlight cells from C7 to C17 in yellow. That happens only if C3 shows true.

Okay, so here's the steps to make it work. First off, select that range, C7 through C17.

Then head over to the Home tab. Click on conditional formatting, and pick new rule from there.

Go with the option that says use a formula to determine which cells to format.

In the box for the formula, type in this [==TRUE].

Now, for why that works. The C$3 part locks the row to 3. So each cell in your range looks back to row 3 in its own column.

It stays dynamic too. Like if you stretch it to D7 through D17, it checks D3. Same for E and so on.

After that, hit format. Choose yellow for the fill color. Click okay.

Then click okay one more time to turn on the rule.