Hi Experts
I am working on spread sheet report and please may I ask 2 questions
1. The weekly report where is consolidated has all previous entries and current week data of sales in histogram
I want to highlight the latest only in a different color with 3d width
2. If the value is above threshold is above say 30, in any of the week, that should be in RED, likewise the total which I represent per week in graph should be of different color.
Your help is much appreciated.
I am working on spread sheet report and please may I ask 2 questions
1. The weekly report where is consolidated has all previous entries and current week data of sales in histogram
I want to highlight the latest only in a different color with 3d width
2. If the value is above threshold is above say 30, in any of the week, that should be in RED, likewise the total which I represent per week in graph should be of different color.
Your help is much appreciated.