Hello all,
Excel newbie here...
I currently have a dataset with last year’s EHS data that I am looking at representing using a RAG through the colour fills in conditional formatting. However, I cannot figure out what the formula should consist of or how to set this up.
Thanks a bunch
Excel newbie here...
I currently have a dataset with last year’s EHS data that I am looking at representing using a RAG through the colour fills in conditional formatting. However, I cannot figure out what the formula should consist of or how to set this up.
- RED – If X is equal to more than 5% on last year’s EHS data
- Amber – if X is at least 5% more on last year’s EHS Data
- Green – if X is less than last year’s EHS data.
Thanks a bunch