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 w...
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