Returning colours from a function
 

I have a spreadsheet with 4 columns - the first contains names of
individuals, and the other 3 are choices they can make. I put a tick next to
the names in the column(s) of their choices. Then I add the 3 choice columns
using a COUNTA function. I'd like to highlight the column with the highest
total in a different colour, so that it stands out. I've looked at
conditional formatting, but this doesn't seen to give the results I need. I
know I've seen this before using a function - possibly IF (where content is
greater than both of he other columns, or greater than one and equal to
another) but haven't a clue how to write this! HELP!

Try selecting all three and use formula=
=if(i1=max($i$1:$k$1),1,"") and format as desired

--
Don Guillett
SalesAid Software

"Annie1904" wrote in message
...
I have a spreadsheet with 4 columns - the first contains names of
individuals, and the other 3 are choices they can make. I put a tick next
to
the names in the column(s) of their choices. Then I add the 3 choice
columns
using a COUNTA function. I'd like to highlight the column with the
highest
total in a different colour, so that it stands out. I've looked at
conditional formatting, but this doesn't seen to give the results I need.
I
know I've seen this before using a function - possibly IF (where content
is
greater than both of he other columns, or greater than one and equal to
another) but haven't a clue how to write this! HELP!

THANK YOU - THANK YOU - THANK YOU! You don't know how many people in my
workplace (of 250) I've asked and only got blank looks or people backing away
from me - I got the answer from you in about 30 minutes! I'm going to find
lots of uses for this. AND I'll be using the discussion groups a lot more in
future!

"Don Guillett" wrote:

Try selecting all three and use formula=
=if(i1=max($i$1:$k$1),1,"") and format as desired

--
Don Guillett
SalesAid Software

"Annie1904" wrote in message
...
I have a spreadsheet with 4 columns - the first contains names of
individuals, and the other 3 are choices they can make. I put a tick next
to
the names in the column(s) of their choices. Then I add the 3 choice
columns
using a COUNTA function. I'd like to highlight the column with the
highest
total in a different colour, so that it stands out. I've looked at
conditional formatting, but this doesn't seen to give the results I need.
I
know I've seen this before using a function - possibly IF (where content
is
greater than both of he other columns, or greater than one and equal to
another) but haven't a clue how to write this! HELP!

Glad to help. Someone once sent me a thank you case of dog food. I don't
have a dog but my son does.

--
Don Guillett
SalesAid Software

"Annie1904" wrote in message
...
THANK YOU - THANK YOU - THANK YOU! You don't know how many people in my
workplace (of 250) I've asked and only got blank looks or people backing
away
from me - I got the answer from you in about 30 minutes! I'm going to
find
lots of uses for this. AND I'll be using the discussion groups a lot more
in
future!

"Don Guillett" wrote:

Try selecting all three and use formula=
=if(i1=max($i$1:$k$1),1,"") and format as desired

--
Don Guillett
SalesAid Software

"Annie1904" wrote in message
...
I have a spreadsheet with 4 columns - the first contains names of
individuals, and the other 3 are choices they can make. I put a tick
next
to
the names in the column(s) of their choices. Then I add the 3 choice
columns
using a COUNTA function. I'd like to highlight the column with the
highest
total in a different colour, so that it stands out. I've looked at
conditional formatting, but this doesn't seen to give the results I
need.
I
know I've seen this before using a function - possibly IF (where
content
is
greater than both of he other columns, or greater than one and equal
to
another) but haven't a clue how to write this! HELP!