Conditional Formatting

S

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

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
 
S

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

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
 
F

FSt1

thanks sheeloo.
i got tied up.

regards
FSt1

Sheeloo said:
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
Click to expand...
 
Top