Hi . This formula does not work. I need a formula that shows the following
Before the middle of the month If column H4 is less 30 % then highlight in red. If column H4 >30% but less then column C4 then highlight in yellow.If column H4> Column C4 then green.
This formula must apply to the remainder of the sheet with column C5 for example requires a different range that it looks at ( I.e : Numbers )
Bookmarks