Forum Discussion
I cannot add conditional formatting to cells with vlookup formulas in them please help!
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!
1 Reply
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()
