conditional formatting for formula resulting in text

[terrapinie]

I have a spreadsheet with a column I would like to conditionally
format. This column contains IF formulas. It says, basically, this:
IF(E1<D1,LOW, IF(E1>D1,E1<C1,MEDIUM, IF(E1>C1,HIGH)))
I would like conditionally format this column so the cells with value
HIGH are shaded red, MEDIUM are yellow, and LOW are green.
I know there is a way to do this - but I couldn't find a conditional
formatting formula that worked while searching through previous
threads.

Thanks,
Laurie

 

[RagDyer]

It's not really a single formula, but one simple stipulation for *each* one
of the three conditions.

Just select a cell in the column, and,

<Format> <ConditionalFormat>
Left window > "CellValueIs"
Next window (middle) > "EqualTo"
Right window > low (*don't* use quotes)
Set your Format,
Then click the "ADD" button to expand to condition 2,
And do the same as above for "med" (no quotes),
And finally expand to condition 3 for "high' (no quotes)

Then click <OK>, and you're done.

Now, click on the format painter icon (yellow paint brush),
And click in the next cell, and drag down as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a spreadsheet with a column I would like to conditionally
format. This column contains IF formulas. It says, basically, this:
IF(E1<D1,LOW, IF(E1>D1,E1<C1,MEDIUM, IF(E1>C1,HIGH)))
I would like conditionally format this column so the cells with value
HIGH are shaded red, MEDIUM are yellow, and LOW are green.
I know there is a way to do this - but I couldn't find a conditional
formatting formula that worked while searching through previous
threads.

Thanks,
Laurie

 

[terrapinie]

Yes, I knew it would be a three part formatting, but I had tried tons
of things and none worked. Who would've thought the simplest choice
would've worked?!

Thanks,
Laurie