Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
How can I make a certain value in "column a" change something in "column b"?
When a cell in "column a" is = "a" I want to change what ever is in the corresponding cell in "column b" to "unbolded". Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
hi
in cell b3 enter into conditoal format dialog.... formula is......=A3<"a"...........format bold copy cell B3 and paste special formats down column B regards FSt1 "Shannon" wrote: How can I make a certain value in "column a" change something in "column b"? When a cell in "column a" is = "a" I want to change what ever is in the corresponding cell in "column b" to "unbolded". Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Ok - when I do that then whatever is in the cells in column b change to the
value from "b3"... How can I make it so the values don't change to "b3"'s value?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Are you selection 'Formats' in the Paste Special dialog box?
To get what you want Select Cell b3 Click on the Paint Brush icon Click on Col B this will copy the formatting to Col B "Shannon" wrote: Ok - when I do that then whatever is in the cells in column b change to the value from "b3"... How can I make it so the values don't change to "b3"'s value?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
thanks sheeloo.
i got tied up. regards FSt1 "Sheeloo" wrote: Are you selection 'Formats' in the Paste Special dialog box? To get what you want Select Cell b3 Click on the Paint Brush icon Click on Col B this will copy the formatting to Col B "Shannon" wrote: Ok - when I do that then whatever is in the cells in column b change to the value from "b3"... How can I make it so the values don't change to "b3"'s value?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |