Excel: IF statement to change cell colour if number is greater/lesser than?

Soldato
Joined
27 Jan 2005
Posts
3,655
Location
Expat in HK
I have a group of numbers in excel ranging from 1000 to 5000 and want an IF statement to make it so if the number is higher than 2800, the numbers change green and if below 2800 they change red.

Any ideas?
 
Back
Top Bottom