Hi everyone
I need a macro to look at a certain range containing different numbers, and by the help of the MAX formula change the font colour on all numbers in the range lower than MAX.
Anybody got an idea?
Hi everyone
I need a macro to look at a certain range containing different numbers, and by the help of the MAX formula change the font colour on all numbers in the range lower than MAX.
Anybody got an idea?
Hello,
you don't need a macro to do that. You can use conditional formatting with a formula like
=A1<Max($A$1:$A$100)
Post a data sample if you need help implementing this. See attached
cheers
Last edited by teylyn; 04-08-2011 at 07:14 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks