condition format row based on cell value

[VbaHell]

This is driving me nuts as it should be easy to complete

Condition format but with two criteria's


Highlight Rows A5:C1000

Criteria 1 =$B3 > 100000 This works fine
Criteria 2 =$B3 > 50000 and < 100000

I know how to set up the condition formatting but Criteria 2 is an issue

Can someone please put me out of my misery

 

[philwojo]

Try this

=and($b3>50000,$b3<100000)

 

[VbaHell]

Perfect, Doh it the simple things
Many thanks

 

[philwojo]

No problem, glad to help and yea, sometimes the simplest things are the easiest to overlook.