Hi All,
I am hoping you guys can help me out here as i have been tearing my hair out over this one. i have an excell sheet with the following fields:
R.1 R.2 R.3 R.4 R.5 R.6 TOT PTS
78 63 53 66 47 0 307
Now upto here easy enogh, my TOT PTS filed is populated with the following formula: =SUM(F3:K3)-SMALL(F3:K3,1), basically adding the 5 biggest values out of R1:R:6, now the tricky part that i can t figure out, how do i get the smallest value, therefore the one which is taken out by -SMALL(F3:K3,1) in the formula, to be automatically displayed in RED???
I have tried using conditional formatiing but my knowledge on that is very slim so any advice is welcome. Thanks.
Bookmarks