Conditional Formatting (more than 3) in Excel
Closed
steve1000
-
May 4, 2009 at 09:04 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 6, 2009 at 10:06 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 6, 2009 at 10:06 PM
Hello,
I want to select a colom containing discription's Example (HATS)(bats)(cats) if this criterea is found i want the rows to the left that corisponds to this colored
I want to select a colom containing discription's Example (HATS)(bats)(cats) if this criterea is found i want the rows to the left that corisponds to this colored
Related:
- Conditional Formatting (more than 3) in Excel
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Five nights in anime 3 - Download - Adult games
- Hitman 3 free download - Download - Action and adventure
- Granny 3 download pc - Download - Horror
2 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 5, 2009 at 11:42 PM
May 5, 2009 at 11:42 PM
Suppose your desired info are in column D, then be selecting column A1 TO B3 or onward put these conditions by selecting formatting ................
Condition 1 : =$D2="HATS"
Condition 2 : =$D2="BATS"
Condition 3 : =$D2="CATS"
Condition 1 : =$D2="HATS"
Condition 2 : =$D2="BATS"
Condition 3 : =$D2="CATS"
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 6, 2009 at 10:06 PM
May 6, 2009 at 10:06 PM
It can be easily done on MS Excel 2007. My macro skill is not good enough but i'll try to check it out ......
May 6, 2009 at 09:22 PM
I want more than 3 and up to 10 conditions
i want to select a colom containing discription's Example (HATS)(bats)(cats)(dogs)(birds) if this criterea is found i want the rows to the left that corisponds to this colored.
It may require a macro, can you supply me one.
Thanks