Forum Discussion
Conditional Formatting Formulas
In column A, I have 10 numbers. I want column B to have conditional formatting where if I enter a number that is higher than 70% of the value in column A, it will turn green. If it’s 70% or lower it will turn red.
3 Replies
You may apply to column B conditional formatting rule for the green with formula
=$B1>0.7*$A1
assuming your range starts from first row. Similar for the red rule.
- This works when I do it for just the first row but How do I apply that formula to all of column B. And not individually typing a formula for each cell in B
It works for your entire range
Please see attached
