Forum Discussion

Deleted's avatar
Deleted
Jan 22, 2018

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...
Charts & Visualizing Data
Excel Desktop
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 29, 2018

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()

 

Resources