mikeman353
New Member
- Joined
- Mar 1, 2011
- Messages
- 3
Hi everyone,
I am looking to do the following with conditional formatting. Basically, going across I have the months of the year, with percents below like the following:
Jan Feb Mar Apr May Jun etc.
55% 54% 52% 52% 50% 65%
Anytime there is a trend up or down of 5% or more (like Jan-May above), I want those cells to highlight. Any tips? Thanks.
I am looking to do the following with conditional formatting. Basically, going across I have the months of the year, with percents below like the following:
Jan Feb Mar Apr May Jun etc.
55% 54% 52% 52% 50% 65%
Anytime there is a trend up or down of 5% or more (like Jan-May above), I want those cells to highlight. Any tips? Thanks.
