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


Duncan Williamson

3 Responses to “Up Arrow Red?”

  1. Preeti Says:

    Fantastic.. It worked…

  2. Leo Funaro Says:

    Please let me know if you’re looking for a article author for your blog. You have some really great articles and I believe I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please shoot me an e-mail if interested. Kudos!

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: