I have about 60 rows of 6 columns with numbers in most of them.
I want to highlight each cell of column E, based on the numbers that are in columns C and D (D will always be higher than C). If Column E is higher than column C but lower than D it should be one color. But If E is higher then D it should be another color, and if it is lower then C it should be a third color
I am assuming it can be done with conditional formatting, but I have never done conditional formating without it being a fixed number.
Thank you
Bookmarks