Conditional Formatting

[Shannon]

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?

 

[FSt1]

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]

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??

 

[Sheeloo]

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

 

[FSt1]

thanks sheeloo.
i got tied up.

regards
FSt1

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