A macro that will enter

Closed
Report
Posts
2
Registration date
Thursday December 3, 2009
Status
Member
Last seen
December 5, 2009
-
Posts
2
Registration date
Thursday December 3, 2009
Status
Member
Last seen
December 5, 2009
-
Hello,
I am looking for a macro that will look at "A:1" and if positive enter "xxx" in "b:1" and color the cell background "yellow" or something from the palette.

I also would appreciate it is someone could help me with another one where "Sheet 2" looks at the information in "sheet one A:1" and if positive enters everything from row one (several columns) including formatting in "Sheet 2".

Any thoughts or ideas will sure be appreciated.

Thank you

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
suppose is A1 is 1
in B1 copy this formula
=IF(A1=1,"xxx","")
then select B1
click format-condtional fomatting
under condition 1
cells value is
in the next small window
choose <equal to>
in the next window type
xxx
click format in the second window right
choose pattern (the last tab on the top)
choose a color
click ok
again click ok


now you can copy B1 down.

study about conditonal formatting it will be useful.(excel help)
Posts
2
Registration date
Thursday December 3, 2009
Status
Member
Last seen
December 5, 2009

Thank you very much!!
As I understand it I can have only three (3) variables in conditional formatting of a cell, I have seven to nine at present. How can I exceed the three limit?