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
drwhicker Posts 2 Registration date Thursday December 3, 2009 Status Member Last seen December 5, 2009 - Dec 5, 2009 at 12:24 AM
Related:
- A macro that will enter
- How to enter @ in laptop - Guide
- Enter key will send your message - Guide
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Automatically run a macro when opening a worksheet - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 4, 2009 at 09:31 PM
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)
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)
drwhicker
Posts
2
Registration date
Thursday December 3, 2009
Status
Member
Last seen
December 5, 2009
Dec 5, 2009 at 12:24 AM
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?
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?
