Apply conditional formatting to a range of cell using formula

0
votes

This is my table: Sheet

What I'm trying to do is to make a conditional formatting rule that will highlight Column-A (Studio).

Here is my formula: If Column-B (Weekend Gross) is greater than $500,000 and Column-C (Total Gross) is greater than $10,000,000. Column A will be formatted with red fill and dark red text.

Formula

Movies sheet

The rule will be applied to Movies(2) sheet. I tried a lot of formula but I do not know why it does not work. Please help me correct my error. Thank you in advance.

1
excelexcel-formulaconditional-formatting

1 Answers

1
votes

Select A2. try this formula:

=AND(B2>500000,C2>10000000)

And use Format Painter (select A2 and click Format painter then select column A)

1