I have six values in cells A1 to F1
each time the sheet calculates I want the cell that is highest in value to be interior Coloured Red and the rest No colour.
Thanks
I have six values in cells A1 to F1
each time the sheet calculates I want the cell that is highest in value to be interior Coloured Red and the rest No colour.
Thanks
conditional formatting, and custom formula enter
=A$1=MAX($A$1:$F$1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks