Ask Your Question
0

how to use colour coding in condtional formatting to show improvement?

asked 2018-11-23 19:43:39 +0200

codiejane gravatar image

I currently am using the conditional formatting tool to show whether my agents are meeting their targets but I am having trouble formatting some to show improvement from previous day but still under target. for example: target for monthly sales is 2.45% Monday the agents percentage was sitting at 0.71 well under target Tuesday the agent was sitting at 1.54 still under target but improved from Monday as I have it now anything under 2.45% is red and equal to and about is green but I am wanting for the stat to turn yellow if they are under target but has made improvement from the previous day. as well as this spreadsheet includes 5 days for I am wanting to have the yellow show based off of the previous day's stat.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-11-24 08:49:04 +0200

ebot gravatar image

updated 2018-11-24 08:50:41 +0200

Go to this TDF Wiki page. On this page is a description of "How to Apply a Color Scale Conditional Formatting". At the bottom of the page is the download for a sample file.

Does this help you ?

If my answer did solve your problem, please click the big checkmark inside the circle to the left of this answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-23 19:43:39 +0200

Seen: 34 times

Last updated: Nov 24 '18