Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i put color in a cell based on data in a second cell
Cell A1 has 8 digit number manually entered each day.
Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of cell A1 will be determined by the single letter in B1. I've looked at conditional formatting, but haven't had much luck. I'm running excel 2003. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i put color in a cell based on data in a second cell
Conditional formatting should work. Tell me what you put in the
conditionally formating boxes. "Diogie" wrote: Cell A1 has 8 digit number manually entered each day. Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of cell A1 will be determined by the single letter in B1. I've looked at conditional formatting, but haven't had much luck. I'm running excel 2003. Can anyone help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i put color in a cell based on data in a second cell
1. Select A1
2. Format |Conditional | Formula is 3. Paste this: =$B$1="A" 4. Format 5. Add 6. Repeat steps 3 to 4 7. You can't specifiy a fourth condition, but you could unconditionally format A1 as the fourth "Diogie" wrote: Cell A1 has 8 digit number manually entered each day. Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of cell A1 will be determined by the single letter in B1. I've looked at conditional formatting, but haven't had much luck. I'm running excel 2003. Can anyone help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i put color in a cell based on data in a second cell
If you need more than 4 conditions you could use event code to color the cell
with many more conditions. If interested, post back. Or use Bob Phillips' 30-condition CFPlus add-in. http://www.xldynamic.com/source/xld.....Download.html Gord Dibben MS Excel MVP On Tue, 4 Sep 2007 14:46:02 -0700, Tevuna wrote: 1. Select A1 2. Format |Conditional | Formula is 3. Paste this: =$B$1="A" 4. Format 5. Add 6. Repeat steps 3 to 4 7. You can't specifiy a fourth condition, but you could unconditionally format A1 as the fourth "Diogie" wrote: Cell A1 has 8 digit number manually entered each day. Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of cell A1 will be determined by the single letter in B1. I've looked at conditional formatting, but haven't had much luck. I'm running excel 2003. Can anyone help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i put color in a cell based on data in a second cell
cell is equal to d then format font bold (or background color pink, etc).
There are a total of 7 letters to be used in B1 calling for either bold font or different color backgrounds in A1. "Darrilyn" wrote: Conditional formatting should work. Tell me what you put in the conditionally formating boxes. "Diogie" wrote: Cell A1 has 8 digit number manually entered each day. Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of cell A1 will be determined by the single letter in B1. I've looked at conditional formatting, but haven't had much luck. I'm running excel 2003. Can anyone help? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i put color in a cell based on data in a second cell
I have a total of 7 letters to be used in B1 which I need to determine the
background or cause the font to be bold in A1. "Gord Dibben" wrote: If you need more than 4 conditions you could use event code to color the cell with many more conditions. If interested, post back. Or use Bob Phillips' 30-condition CFPlus add-in. http://www.xldynamic.com/source/xld.....Download.html Gord Dibben MS Excel MVP On Tue, 4 Sep 2007 14:46:02 -0700, Tevuna wrote: 1. Select A1 2. Format |Conditional | Formula is 3. Paste this: =$B$1="A" 4. Format 5. Add 6. Repeat steps 3 to 4 7. You can't specifiy a fourth condition, but you could unconditionally format A1 as the fourth "Diogie" wrote: Cell A1 has 8 digit number manually entered each day. Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of cell A1 will be determined by the single letter in B1. I've looked at conditional formatting, but haven't had much luck. I'm running excel 2003. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
How to sum data based on font or cell color? | Excel Worksheet Functions | |||
Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
How do I change fill color in excel based on data in the cell | Excel Worksheet Functions |