A macro that will enter

Closed
drwhicker Posts 2 Registration date Thursday December 3, 2009 Status Member Last seen December 5, 2009 - Dec 4, 2009 at 05:35 PM
drwhicker Posts 2 Registration date Thursday December 3, 2009 Status Member Last seen December 5, 2009 - Dec 5, 2009 at 12:24 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 4, 2009 at 09:31 PM
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)
0
drwhicker Posts 2 Registration date Thursday December 3, 2009 Status Member Last seen December 5, 2009
Dec 5, 2009 at 12:24 AM
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?
0