Forum Discussion

Copper Contributor

Oct 28, 2020

Solved

Conditional Formatting Cells In Column Based On Vlookup In Another Column

Goal - I'm trying to get information in column B to carry a conditional format (changing the font color to blue) based on finding a match from a VLookup in column C. I've attached a sample spreadshee...

Sample.xlsx11 KB

excel

office 365

Riny_van_Eekelen
Oct 28, 2020
RHughes11569 Perhaps like in the attached workbook?

Sample.xlsx11 KB

Riny_van_Eekelen

Platinum Contributor

Oct 28, 2020

RHughes11569 Perhaps like in the attached workbook?

Sample.xlsx11 KB

RHughes11569
Copper Contributor
Oct 28, 2020
YES!!! Thank you! I knew it was straight-forward, but it just wasn't working for me. I pulled up the formulas side by side and it turns out mine was putting apostrophes around my VLookup cells. I removed those and it now works like a charm.