Register
Log In
Unanswered
Home
August 24, 2016
Offline
I would like to use conditional formatting using Data Bar or Icon Set on below result - sales performance to attract attention. I have read the tutorial but still not sure how to use it
. I have applied the formula - "IF" on the remarks, =If(C3>B3,"over-forecast","under-forecast").
would you please help. Thank you.
Estella
| SKU | FORECAST | ACTUAL SALES | VARIANCE | REMARKS |
| APPLE | 3000 | 2900 | -100 | UNDER-FORECAST |
| ORANGE | 2600 | 1500 | -1100 | UNDER-FORECAST |
| KIWI | 900 | 2000 | 1100 | OVER-FORECAST |
| AVOCADO | 1800 | 1900 | 100 | OVER-FORECAST |
| PEAR | 560 | 1000 | 440 | OVER-FORECAST |
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
