Conditional formatting using formula and if, then

[Pati Murdock]

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 cell in that row that is part of the result is too low to matter about. Here it is in words:

If B6>2, then conditionally format B6:D6 (red if D6 less than 32%, yellow if D6 between 32 & 38%, green if D6 above 38%)

[#2]

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.