Highlight the particular cell in Kingsoft Spreadsheet

[treeppm]

Hello friends. I'm using following formula

To get result highlight last two largest number in particular cell range( in this case from C3 to E7)

But I like to have result like this.. when it highlight the two cells with in the range. the Time and range also should be highlighted. Kindly look the following image closer

and when it meet's with in same range the color should change as different

and this..

May someone help me to get like this?...

I'm extremely sorry for my bad English. I hope u'll understand by seeing the images.

Thanks in advance

 

[Sixthsense]

Re: Highlight the particular cell in Excel

Unable to locate the image and also it will be helpful to provide exact solution if you upload the file somewhere in the web and provide the link to download.

 

[Smitty]

Re: Highlight the particular cell in Excel

Welcome to the Board!

And what application are you using? Doesn't look like Excel to me...

 

[treeppm]

Re: Highlight the particular cell in Excel

Unable to locate the image and also it will be helpful to provide exact solution if you upload the file somewhere in the web and provide the link to download.

Kindly follow the link. Pictures.rar

 

[treeppm]

Re: Highlight the particular cell in Excel

Welcome to the Board!

And what application are you using? Doesn't look like Excel to me...

Yes bro .. it's kingsoft office spreadsheet... but we can use all the same method and calculations in this