Conditional formatting works for one column but not another

%3CLINGO-SUB%20id%3D%22lingo-sub-1801057%22%20slang%3D%22en-US%22%3EConditional%20formatting%20works%20for%20one%20column%20but%20not%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801057%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20in%20the%20conditional%20formatting%20rules%20cells%20are%20being%20compared%20against%20another%20cell%20in%20the%20row%20then%20given%20a%20green%2Fyellow%2Fred%20colour%20depending%20on%20its%20amount.%20I've%20applied%20the%20same%20rules%20to%20both%20columns%20but%20column%20E%20works%20and%20column%20B%20won't%20display%20the%20Green%20colour%20despite%20the%20rules%20almost%20being%20identical%20to%20E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20the%20rules%20I've%20used%20and%20what%20its%20outputting%20on%20my%20document.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S%2C%20not%20sure%20why%20it%20is%20not%20letting%20attach%20the%202nd%20picture%20in%20the%20series%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1801057%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801151%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20works%20for%20one%20column%20but%20not%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801151%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839691%22%20target%3D%22_blank%22%3E%40soundmagnet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20order%20of%20rules%20in%20the%20Manage%20Conditional%20Formatting%20Rules%20dialog%20is%20important.%20The%20rules%20for%20column%20D%20are%20in%20a%20different%20order%20than%20those%20for%20column%20E.%20You%20can%20move%20rules%20up%20and%20down%20in%20this%20dialog%20using%20the%20%5E%20and%20v%20buttons.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801251%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20works%20for%20one%20column%20but%20not%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801251%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839691%22%20target%3D%22_blank%22%3E%40soundmagnet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20addition%2C%20you%20don't%20need%20so%20many%20rules%2C%20in%20general%20for%20one%20color%20is%20enough%20one%20rule.%20In%20you%20case%20you%20may%20apply%20%3DD2%26gt%3B%3D%24G2%20to%20%24D%242%3A%24E%2483%20for%20the%20green%2C%20same%20with%20other%20colors.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

So in the conditional formatting rules cells are being compared against another cell in the row then given a green/yellow/red colour depending on its amount. I've applied the same rules to both columns but column E works and column B won't display the Green colour despite the rules almost being identical to E. 

 

I've attached the rules I've used and what its outputting on my document. 

 

Thanks. 

 

P.S, not sure why it is not letting attach the 2nd picture in the series here.

4 Replies
Highlighted

@soundmagnet 

The order of rules in the Manage Conditional Formatting Rules dialog is important. The rules for column D are in a different order than those for column E. You can move rules up and down in this dialog using the ^ and v buttons.

Highlighted

@soundmagnet 

In addition, you don't need so many rules, in general for one color is enough one rule. In you case you may apply =D2>=$G2 to $D$2:$E$83 for the green, same with other colors.

Highlighted

Both solutions worked. Thanks. 

Highlighted