J
jaykoski99x
If you take a look at my example below... We'll say I'm selling widgets. I
need my crew to average 4500 widgets in my two week period. I can use
conditional formatting to make the number in the "Avg" column green if they
sell good, red if they sell bad (or whichever text colors, formats, etc).
I've got that down.
What if instead of formatting my "Avg" column, I put in a column to
designate whether they did "OK" or not? For instance, Ben sold ABOVE the
average I'm looking for, and I want a special character like a green check
mark to populate in my "OK" column. Conversely, Quark sold BELOW the average
I'm looking for, and I want a special character like a red "X" to populate in
my "OK" column.
I'm sure that it involves some of the IF, THEN, AND stuff that I'm really
weak on. Any ideas on this puzzle?
Week 1 Week 2 Avg OK?
Ben 8627 5136 6882
Julian 3578 5648 4613
Kira 1597 5975 3786
Odo 5684 5812 5748
Quark 3248 5211 4230
Miles 4008 9855 6932
Jake 6032 6871 6452
Dax 5352 8988 7170
need my crew to average 4500 widgets in my two week period. I can use
conditional formatting to make the number in the "Avg" column green if they
sell good, red if they sell bad (or whichever text colors, formats, etc).
I've got that down.
What if instead of formatting my "Avg" column, I put in a column to
designate whether they did "OK" or not? For instance, Ben sold ABOVE the
average I'm looking for, and I want a special character like a green check
mark to populate in my "OK" column. Conversely, Quark sold BELOW the average
I'm looking for, and I want a special character like a red "X" to populate in
my "OK" column.
I'm sure that it involves some of the IF, THEN, AND stuff that I'm really
weak on. Any ideas on this puzzle?
Week 1 Week 2 Avg OK?
Ben 8627 5136 6882
Julian 3578 5648 4613
Kira 1597 5975 3786
Odo 5684 5812 5748
Quark 3248 5211 4230
Miles 4008 9855 6932
Jake 6032 6871 6452
Dax 5352 8988 7170