• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting and Decimals


New Member
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 ?