I cannot add conditional formatting to cells with vlookup formulas in them please help!

[Deleted]

I am attempting to add the 3-color gradient scale conditional formatting:

If =C2 is <=20 the row should be red

If =35<=C2<=40 that row should be yellow 

If  =c2>=70 that row should be green

A separate format for:

and If =C2=90 that row should be gray

If I input a number in the C column it will reflect these conditions however with the VLOOKUP formula in these cells the conditional formatting does not show. Please help!

[#2]

Hi Kaia,

Status numbers in your Sheet2 are stored as text, thus VLOOKUP returns text and that's why conditional formatting doesn't work.

You may convert Status to numbers or return VALUE() from your VLOOKUP()