max,

Its work..

If i have 100 over cells in the table, meaning i have to do the CF one by one?

"Max" wrote:

"Will" wrote:
it dun work. I believ only array can.

It works fine as suggested. Either you didn't try it (did you?) or you
applied it incorrectly.

Attached is a sample which evidences the suggestion works:
http://www.savefile.com/files/628657
CF to highlight top 3.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---