| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make automatic coloring in a cell vth conditions attache
Suppose Cell A1 = x, then I want to color B1 black
& when Cell A1 = y, then I want to color B1 blue |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make automatic coloring in a cell vth conditions attache
What version of Excel are you using?
Biff "SPM" wrote in message ... Suppose Cell A1 = x, then I want to color B1 black & when Cell A1 = y, then I want to color B1 blue |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make automatic coloring in a cell vth conditions attache
Format/ Conditional formatting/ Formula is ...
-- David Biddulph "SPM" wrote in message ... Suppose Cell A1 = x, then I want to color B1 black & when Cell A1 = y, then I want to color B1 blue |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make automatic coloring in a cell vth conditions atta
version 2000
"T. Valko" wrote: What version of Excel are you using? Biff "SPM" wrote in message ... Suppose Cell A1 = x, then I want to color B1 black & when Cell A1 = y, then I want to color B1 blue |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make automatic coloring in a cell vth conditions atta
Try this:
Select cell A1 Goto the menu FormatConditional Formatting Condition 1 Formula Is: =A1="x" Click the format button Select the style(s) desired OK Click the Add button Condition 2 Formula Is: =A1="y" Click the format button Select the style(s) desired OK out Biff "SPM" wrote in message ... version 2000 "T. Valko" wrote: What version of Excel are you using? Biff "SPM" wrote in message ... Suppose Cell A1 = x, then I want to color B1 black & when Cell A1 = y, then I want to color B1 blue |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make automatic coloring in a cell vth conditions atta
To change B1 cell you must select B1(not A1) then follow Biff's post from
Condition1 onward using =A1="x" etc.. Gord Dibben MS Excel MVP On Wed, 23 May 2007 12:57:41 -0400, "T. Valko" wrote: Try this: Select cell A1 Goto the menu FormatConditional Formatting Condition 1 Formula Is: =A1="x" Click the format button Select the style(s) desired OK Click the Add button Condition 2 Formula Is: =A1="y" Click the format button Select the style(s) desired OK out Biff "SPM" wrote in message ... version 2000 "T. Valko" wrote: What version of Excel are you using? Biff "SPM" wrote in message ... Suppose Cell A1 = x, then I want to color B1 black & when Cell A1 = y, then I want to color B1 blue |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make automatic coloring in a cell vth conditions atta
Ooops!
Biff "Gord Dibben" <gorddibbATshawDOTca wrote in message ... To change B1 cell you must select B1(not A1) then follow Biff's post from Condition1 onward using =A1="x" etc.. Gord Dibben MS Excel MVP On Wed, 23 May 2007 12:57:41 -0400, "T. Valko" wrote: Try this: Select cell A1 Goto the menu FormatConditional Formatting Condition 1 Formula Is: =A1="x" Click the format button Select the style(s) desired OK Click the Add button Condition 2 Formula Is: =A1="y" Click the format button Select the style(s) desired OK out Biff "SPM" wrote in message ... version 2000 "T. Valko" wrote: What version of Excel are you using? Biff "SPM" wrote in message ... Suppose Cell A1 = x, then I want to color B1 black & when Cell A1 = y, then I want to color B1 blue |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make automatic coloring in a cell vth conditions attache
Thnx Boss. Got it. Doing fine. Thank you once again.
"SPM" wrote: Suppose Cell A1 = x, then I want to color B1 black & when Cell A1 = y, then I want to color B1 blue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn off automatic fill coloring in excel | Excel Discussion (Misc queries) | |||
| How do I turn off automatic fill coloring in excel | Excel Discussion (Misc queries) | |||
| Automatic coloring of blank cells when sheet work complete | Excel Worksheet Functions | |||
| want to make a bubble graph with 20 bubbles and gradient coloring. | Charts and Charting in Excel | |||
| Excel should allow automatic tab coloring. | Setting up and Configuration of Excel | |||
Linear Mode
