clear me the doubt in copnditional formatting

[N.sangeetha]

hi..
i have been working in Excel 2003,there are some queries in conditional fromatting,how to create a conditional format to highlight the highest value with blue color and lowest value with red color? do clear my doubt as soon as possible.

Thanks
Sangeetha

[Pepe Le Mokko]

Use the MIN and MAX functions in your CF

[N.sangeetha]

Use the MIN and MAX functions in your CF

hi.. i worked on it.. i got it thanks..

[Pepe Le Mokko]

You're welcome