Forum Discussion
Conditional formatting using formula and if, then
I want to conditionally format a row one 1 of 3 colors depending on one of the cells in the row being at, above or below goal. I know how to do that--easy peasy. But I want to ignore formatting if a ...
Hi Pati,
Please find bellow a solution.
To achieve your goal you have to create a customised conditionnal formating using a formule.
The important thing is because you want to apply a conditionnal formating on a cell based on the value of another one you have to fix the columns but not the rows in you cells references.
I added three 3 formulas to let you understand the result you will get.
Let me know if this helped you.