highlet background color max and min values year wise

[#1]

Hi

I have scenario

i need to highlet background colur based on year

For example

12

means in 12 months one max and one min vlaue i need to highlet

24

means  i need to highlet 2 min and 2 max values

i.e. for every 12 months i need to highlet  one min and one max value

Please find the attachedcand do the needful

Thiru

[sunny_talwar]

Glad it did

[#3]

Hi Sunny,

I have changed the formula

for Growth

Sum(Sales)-Sum(Prev_Sales))/Sum(Prev_Sales) to

Sum(Sales)-Sum(Prev_Sales))

but it is not working when i change the formula,is there any other thing we need to chnage here?

Please do the needful

Thiru

[sunny_talwar]

Please start a new thread for new requirements.

Best,

Sunny

[#5]

ok

Sunny