Conditional Formatting Not Working

[deemer98]

I set up my conditional formatting to turn text green if equal to or less than 5.25 and red if greater than 5.25. No matter what number shows up in the cell, they are always green. This cell is a percentage if that matters.

I went to another cell to test it on a simple one, but not a percentage. If the cell is equal to or less than 82000, turn to green text and if it is greater than 82000, turn to red text. It always turns green no matter if above or below. Frustrated! Please help! Thanks!

 

[kweaver]

Did you set 2 conditions, one for each situation?

 

[JoeMo]

Tell us exactly how you set up the conditional formatting.

 

[ClaireS]

Also, check that your numbers are really numbers. For example, if they are derived using a text formula, e.g. LEFT, RIGHT, MID, they will be text values that happen to contain only digits, so will have a numerical value of 0. If this is the case, wrap your function in a VALUE function.

 

[deemer98]

Yes, that is correct. As Claire replied below, the cell is the result of dividing two other cells. Thank you!

 

[deemer98]

Yes, the number in that cell is a result of dividing two other cells. I’m not sure how to use the value function at you suggested. Can you assist with that please? Thank you!

 

[ClaireS]

Could you post some sample data and your formula to show the problem, also your Conditional Format settings.

 

[deemer98]

I want cell J3:J31 to turn green if less than or equal to 5.25 or red if greater than 5.25. Each J cell is a result of subtracting cells I4 by F4. All cells display as a % if that matters.

I don't have any conditional formatting in there right now because I can't figure it out

This is the current formula: =IFERROR(I4-F4, "")

 

[ClaireS]

All cells display as a % if that matters​

That could be the problem. Set up your conditional formatting to look for values less/greater than 0.0525. The percent format multiplies the number by 100 and sticks a % sign on the end - but the underlying value is actually 0.0525 for 5.25%.

 

[deemer98]

YES!!!! Works perfectly! Thank you very much!