Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Background color according to a specific cell value
Hello,
I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and B10 to see their backgroubnd color change depending of the info fond in cell B9... I knwo I must use "Conditional Formating" but I just don't know exactly what I need to enter as information. Thanks in advance to all for any assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Background color according to a specific cell value
hi
we don't either. what is in B9? what conditon(s) would change the color? regards FSt1 "One-Leg" wrote: Hello, I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and B10 to see their backgroubnd color change depending of the info fond in cell B9... I knwo I must use "Conditional Formating" but I just don't know exactly what I need to enter as information. Thanks in advance to all for any assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Background color according to a specific cell value
There will be 2 values in B9 (in a drop down list)...
OPEN CLOSED When OPEN is selected, I want the cells to remain white. When CLOSED is selected, I want all cells mentionned bellow to turn grey. "FSt1" wrote: hi we don't either. what is in B9? what conditon(s) would change the color? regards FSt1 "One-Leg" wrote: Hello, I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and B10 to see their backgroubnd color change depending of the info fond in cell B9... I knwo I must use "Conditional Formating" but I just don't know exactly what I need to enter as information. Thanks in advance to all for any assistance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Background color according to a specific cell value
In the Conditional Formatting wizard, select Formula Is from the drop down
box and use the formula =$B$9="criteria" and then you can use hte format painter to apply this to all cells. As posted by FSt1, you didn't specify what was in B9 -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "One-Leg" wrote: Hello, I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and B10 to see their backgroubnd color change depending of the info fond in cell B9... I knwo I must use "Conditional Formating" but I just don't know exactly what I need to enter as information. Thanks in advance to all for any assistance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Background color according to a specific cell value
Thanks!!! It worked like a charm...
"M Kan" wrote: In the Conditional Formatting wizard, select Formula Is from the drop down box and use the formula =$B$9="criteria" and then you can use hte format painter to apply this to all cells. As posted by FSt1, you didn't specify what was in B9 -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "One-Leg" wrote: Hello, I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and B10 to see their backgroubnd color change depending of the info fond in cell B9... I knwo I must use "Conditional Formating" but I just don't know exactly what I need to enter as information. Thanks in advance to all for any assistance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Background color according to a specific cell value
hi
better. select B1 on the menu bar... formatconditional format formula is.......=B$9="Closed"..........format gray ok. copy B1. paste in desired cells. done Regards FSt1 "One-Leg" wrote: There will be 2 values in B9 (in a drop down list)... OPEN CLOSED When OPEN is selected, I want the cells to remain white. When CLOSED is selected, I want all cells mentionned bellow to turn grey. "FSt1" wrote: hi we don't either. what is in B9? what conditon(s) would change the color? regards FSt1 "One-Leg" wrote: Hello, I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and B10 to see their backgroubnd color change depending of the info fond in cell B9... I knwo I must use "Conditional Formating" but I just don't know exactly what I need to enter as information. Thanks in advance to all for any assistance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Background color according to a specific cell value
Let's say you want B1 to be red when B9 has value 10 or more
Select B1; use Format | Conditional Formatting In dialog: Formula is =B9=10; now pick the format Click Ok Your done best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "One-Leg" wrote in message ... Hello, I have a document in which I want cells B1, B2, B3, B4, B5, B6, B7, B8 and B10 to see their backgroubnd color change depending of the info fond in cell B9... I knwo I must use "Conditional Formating" but I just don't know exactly what I need to enter as information. Thanks in advance to all for any assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Background Color | Excel Worksheet Functions | |||
cell background color and cell text color | Excel Worksheet Functions | |||
How do I- IF the cell background is RED in color then contain 1 | Excel Worksheet Functions | |||
how to count cells with specific format (background color)? | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |