Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change fill color of cell
Hello,
Excel 2k on Vista 64 bit. I have a range of cells (b2:bn2) in a row that are answers to a quiz. In the same cells below are the answers with a different quiz participant in each row. I would like to change the background of the cells that do not match the answers in b2:bn2. I have used conditional formatting and accomplished this task, however, I would also like to total the wrong answers in column "bo" for every row. I have found a bit of programming on line but it doesn't work with conditional formatting. It does work when I format the cells by hand. Any suggestions? Thanks for your input. Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change fill color of cell
The contents of cells b2:bn2 are text, letters A thru E, corresponding to
the correct letter in multiple choice answers. Sorry for not including in original post. Bill "BillP" wrote in message ... Hello, Excel 2k on Vista 64 bit. I have a range of cells (b2:bn2) in a row that are answers to a quiz. In the same cells below are the answers with a different quiz participant in each row. I would like to change the background of the cells that do not match the answers in b2:bn2. I have used conditional formatting and accomplished this task, however, I would also like to total the wrong answers in column "bo" for every row. I have found a bit of programming on line but it doesn't work with conditional formatting. It does work when I format the cells by hand. Any suggestions? Thanks for your input. Bill |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change fill color of cell
Put this formula in BO3 and copy it down as needed...
=SUMPRODUCT((B3:BN3<"")*($B$2:$BN$2=B3:BN3)) Note: This formula will work independently from your Conditional Formatting (that is, it will work whether you are using Conditional Formatting or not). -- Rick (MVP - Excel) "BillP" wrote in message ... The contents of cells b2:bn2 are text, letters A thru E, corresponding to the correct letter in multiple choice answers. Sorry for not including in original post. Bill "BillP" wrote in message ... Hello, Excel 2k on Vista 64 bit. I have a range of cells (b2:bn2) in a row that are answers to a quiz. In the same cells below are the answers with a different quiz participant in each row. I would like to change the background of the cells that do not match the answers in b2:bn2. I have used conditional formatting and accomplished this task, however, I would also like to total the wrong answers in column "bo" for every row. I have found a bit of programming on line but it doesn't work with conditional formatting. It does work when I format the cells by hand. Any suggestions? Thanks for your input. Bill |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change fill color of cell
Thank you Rick,
Worked perfect! Bill "Rick Rothstein" wrote in message ... Put this formula in BO3 and copy it down as needed... =SUMPRODUCT((B3:BN3<"")*($B$2:$BN$2=B3:BN3)) Note: This formula will work independently from your Conditional Formatting (that is, it will work whether you are using Conditional Formatting or not). -- Rick (MVP - Excel) "BillP" wrote in message ... The contents of cells b2:bn2 are text, letters A thru E, corresponding to the correct letter in multiple choice answers. Sorry for not including in original post. Bill "BillP" wrote in message ... Hello, Excel 2k on Vista 64 bit. I have a range of cells (b2:bn2) in a row that are answers to a quiz. In the same cells below are the answers with a different quiz participant in each row. I would like to change the background of the cells that do not match the answers in b2:bn2. I have used conditional formatting and accomplished this task, however, I would also like to total the wrong answers in column "bo" for every row. I have found a bit of programming on line but it doesn't work with conditional formatting. It does work when I format the cells by hand. Any suggestions? Thanks for your input. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change color fill when data in cell changes | Excel Discussion (Misc queries) | |||
Change cell fill color options | Excel Discussion (Misc queries) | |||
Cell Fill Color change for MAX value | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Change cell fill color from function | Excel Programming |