I have my current number("cur") and alternative number("alt") and I want the current cell color to reflect the the variance between the current and alternative number, green for being 5 less than the alternative and yellow for being equal and red for being 5 more, which should all be explained in the file. I use formulas to create this formatting and I put them outside the conditional formatting settings to make it easier to edit the formulas.
Anyway, it's not working and IDK why. Might you? Thanks
Bookmarks