or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 101 watchers
SPR
SPR
Apr 2019
12:16pm, 5 Apr 2019
27,685 posts
  •  
  • 0
SPR
Greater than is a specific option in conditional formatting so once you know how to use it, it'll be easy.
SPR
SPR
Apr 2019
12:17pm, 5 Apr 2019
27,686 posts
  •  
  • 0
SPR
Specific option under highlight rules.
Stander
Stander
Apr 2019
12:21pm, 5 Apr 2019
15,791 posts
  •  
  • 0
Stander
Damn, I've fiddled and sort of worked it out, but the damn thing wants to highlight cells of equal value.
SPR
SPR
Apr 2019
12:29pm, 5 Apr 2019
27,687 posts
  •  
  • 0
SPR
That would be because you've selected greater than or equal to rather than just greater than I'd guess.
Stander
Stander
Apr 2019
12:37pm, 5 Apr 2019
15,792 posts
  •  
  • 0
Stander
Nope
Even used =round on the two cells to eliminate minor differences
SPR
SPR
Apr 2019
1:08pm, 5 Apr 2019
27,688 posts
  •  
  • 0
SPR
For the ones that look equal but are still being highlighted, what does =cell ref=cell ref produce?
SPR
SPR
Apr 2019
1:11pm, 5 Apr 2019
27,689 posts
  •  
  • 0
SPR
Or you could use =EXACT(cell ref1, cell ref2)
Curly45
Curly45
Apr 2019
1:35pm, 5 Apr 2019
3,877 posts
  •  
  • 0
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
Stander
Apr 2019
5:20pm, 5 Apr 2019
15,793 posts
  •  
  • 0
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
Curly45
Apr 2019
5:24pm, 5 Apr 2019
3,878 posts
  •  
  • 0
Curly45
Hahaha everyone loves the colours! Well done.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work








Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 113,932 Fetchies!
Already a Fetchie? Sign in here