Excel 2013 conditional formatting not working correctly

0
votes

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

1
excelexcel-2013
I can't tell enough from your post to provide any suggestions. From what I can see, you are saying that if the value in cell N3 is greater than 30, color some unspecified cells green, if cell N3 is less than 30, color those cells red, and if the value is equal to 30, do nothing. You don't explain what is happening instead, you don't say what cells you are trying to color, and the image doesn't show the value in cell N3, so the image doesn't give any help at all. So, please clarify your problem and include the information that we need to have to be able to solve it. - BobRodes
As a general rule, using the word "work" anywhere in your explanation of your problem pretty much guarantees that nobody else will be able to understand it. You're the only person who knows what "work" means to you. :) - BobRodes
Oops sorry about that it seems the text i added to the picture isn't there. So the box N3 which has the value 11.46 in it is the one that i have formatted. There are multiple other as well but lets focus on that for now. You can clearly see that it is below 30 yet it is colored red when it should be colored green. I am having this issue across multiple conditional formatting formulas, even the most basic ones as above. Does that explain it better? - Corey
It does. What is the currently selected cell in this image, please? - BobRodes
The cell is N3 which has a value of 11.46 currently - Corey

1 Answers

1
votes

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