If Formula with Conditional formatting to color and text

[troywinston]

Hi Guys,

Another problem here:
below shows 3 tables
1. key 2. AVG calculations each cell based on some raw data 3. Final output, need to show based on 1 and 2, color and "equivalent status e.g Low, Medium, etc.

I am attempting to use IF statement formula with conditional formating to derive tabel 3.

new rule 1. If (E1<5, "Low") then
new rule 2. If (E1>15,"Critical")
new rule 3. If AND(E1>5,E1<=10, "Medium")
new rule 4. If AND(E1>10,E1<=15, "High")pic1.PNGpic2.PNG

[protonLeah]

CF does not add text to cells. The syntax for CF formulas is:
just: =E1<5, not
=If(E1<5...

[63falcondude]

To get the result shown in your "Final Output Required Table", I would use a formula in the cells to get the text and then Conditional Formatting to get the fill color.

[troywinston]

Thanks a lot Guys,

As per suggestion I used formula in the cells to get text and then Conditional formatting to get the fill color.

[63falcondude]

Great, glad we could help.

If that solved your question, please mark this thread as SOLVED.

[troywinston]

silly question ..where do I find status or options to mark SOLVED