I am trying to put 2 conditional formats on a cell that contains a rounded number. The format is: if the number in the cell is greater than X +2%, then show green; if it's less than X-2%, show red. The problem seems to be with the rounded number. For instance, my conditionally formatted cell contains the number 7.77 but shows as 8. In this case "X" is 10. The result shouldn't be red but that is the way it is showing. How can I fix this?
Thanks!
Thanks!