Validation

[IanT]

Hi

I have a row of data:

409 432 333 477 355 314

What I want to do is highlight the figure/cell if it goes above 500 or below 300. Is there a way of doing this.

Ta

 

[KenHigg]

You may be able to do it with conditional formatting...

ken

 

[unmarkedhelicopter]

"Format" - "Conditional Formatting", formula is
=A1>500
and
=A1<300
then format them as you wish