Hi Everyone, maybe a silly question - but I am trying to add up a series of numbers and get the average. Normally comes out like 2.5 or 1.78 or something. Is there a way to make it round up (not just remove decimal point 
) when you apply conditional formatting to say if = 2 turn red or if = 1 turn green, it doesnt appear to work until I make it <=2.5 or something similar. So Ideally trying to make to nearest decimal ?
) when you apply conditional formatting to say if = 2 turn red or if = 1 turn green, it doesnt appear to work until I make it <=2.5 or something similar. So Ideally trying to make to nearest decimal ?