I need to change cell color based on value compared to adjacent cells. I've tried conditional formatting but it is only changing fill to red and green, nothing is yellow. I'm wondering if it because I'm applying three types of cond formatting to the same range. Also, the report will be run weekly so I'd like it to add a new column at the end since the range is dynamic.
My parameters and an example are below.
0% - 5% - Red Fill
5% - 15% - Yellow Fill
Over 15% - Green Fill
Columns F9 - AH161 contains values
Columns AL9 & AM161 contain goals
i.e. If any cells
F9:AH9 < $AL9 = Red
F9:AH9 > $AL9 and < AM9 = Yellow
F9:AH9 > $Am9 = Green
Bookmarks