In my class today we were talking about conditional formatting and since they already knew about it I didn’t say much. Then a delegate asked me a question about their use of conditional formatting. She said they want to show changes in manpower from period to period and from base period … but that if there was a positive variance that was bad and an up arrow should be RED not green and vice versa.
My initial attempts at solving the problem weren’t any good/acceptable so I said it would be my homework. Here is the spreadsheet I put together:
You can see the arrows in cells D7 and D8 and so on and the instructions are in the green text box.
Of course, it’s not a pure solution but it works.
If you did this at work I think you would get some brownie points!!