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:

 

condit_format_red_up_arrow

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!!

 

Duncan Williamson

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: