Dianna
Reputation: 55
Apply conditional formatting to a range of cell using formula
This is my table:
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.
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.
Upvotes: 0
Views: 631
Answers (1)
bzimor
Reputation: 1628
Select A2. try this formula:
=AND(B2>500000,C2>10000000)
And use Format Painter (select A2 and click Format painter then select column A)
Upvotes: 1
Related Questions
- Conditional formatting of a range based on another range in google sheet
- Conditional Formatting to range
- Google Sheets conditional formatting based on a series of values in a range
- Excel VBA - apply conditional formatting formula to range
- Excel: Conditional Formatting based on ranges
- Google Sheets conditional formatting if value in range
- Apply Conditional Formatting to Range but Only Format Cell Where Condition Is True
- Conditionally formatting a range based on a specific cell's value
- Excel apply conditional formatting on the basis of a cell outside range
- Excel 2007- Conditional Formatting- Formatting a cell based on values in a range of cells