for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

SPR Apr 2019 12:16pm, 5 Apr 2019 27,685 posts	Quote Pin SPR Greater than is a specific option in conditional formatting so once you know how to use it, it'll be easy.
SPR Apr 2019 12:17pm, 5 Apr 2019 27,686 posts	Quote Pin SPR Specific option under highlight rules.
Stander Apr 2019 12:21pm, 5 Apr 2019 15,791 posts	Quote Pin Stander Damn, I've fiddled and sort of worked it out, but the damn thing wants to highlight cells of equal value.
SPR Apr 2019 12:29pm, 5 Apr 2019 27,687 posts	Quote Pin SPR That would be because you've selected greater than or equal to rather than just greater than I'd guess.
Stander Apr 2019 12:37pm, 5 Apr 2019 15,792 posts	Quote Pin Stander Nope Even used =round on the two cells to eliminate minor differences
SPR Apr 2019 1:08pm, 5 Apr 2019 27,688 posts	Quote Pin SPR For the ones that look equal but are still being highlighted, what does =cell ref=cell ref produce?
SPR Apr 2019 1:11pm, 5 Apr 2019 27,689 posts	Quote Pin SPR Or you could use =EXACT(cell ref1, cell ref2)
Curly45 Apr 2019 1:35pm, 5 Apr 2019 3,877 posts	Quote Pin Curly45 Are you doing one set at a time? The tool tries to apply to a whole range so you have to make it work on two cells as you want, then remove the correct $ bits (these make the formula absolute rather than the relative you want) and drag to the rest of the cells so that the formula updates...
Stander Apr 2019 5:20pm, 5 Apr 2019 15,793 posts	Quote Pin Stander Farted about a lot, but worked it our eventually. I had to set three separate rules for the cells I wanted highlighted. One if greater, one if less and the final one if the same. Odd. But it now works and my the boss at my new job suitably impressed with some pretty colours.
Curly45 Apr 2019 5:24pm, 5 Apr 2019 3,878 posts	Quote Pin Curly45 Hahaha everyone loves the colours! Well done.