CODEWITHSUNDEEP
excelexcel-2013
Corey
Corey

Reputation: 1

Excel 2013 conditional formatting not working correctly

I have an issue with Excel 2013. The conditional formatting just will not work. I've got a VLOOKUP which pulls data from another worksheet. Then I want to use conditional formatting on that data. The conditions are =$N$3>30 to color the cell red and =$N$3<30 to color the cell green. It just stays permanently red or permanently green. I've tried every solution and possible work around I can think of and nothing works.

Does any one have any suggestions?

enter image description here

Upvotes: 0

Views: 320

Answers (1)

matley
matley

Reputation: 99

Value in your N3 (or in column N), is a text thus color is red. Add double dash (--) to your VLookup function to convert the result to number. Your formula should be =IFERROR(--VLOOKUP(A3,... (complete the formula).

Upvotes: 1

Related Questions