Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |