Conditional Formatting (more than 3) in Excel
Closed
steve1000
-
4 May 2009 à 21:04
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 6 May 2009 à 22:06
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 6 May 2009 à 22:06
Related:
- Conditional Formatting (more than 3) in Excel
- Psiphon 3 - Download - VPN
- Excel clear formatting - Guide
- Hitman 3 cheats - Guide
- How to change date format in excel - Guide
- Five nights in anime 3 - Download - Adult games
2 responses
mubashir aziz
Posts
190
Registration date
Sunday 12 April 2009
Status
Member
Last seen
16 February 2010
166
5 May 2009 à 23:42
5 May 2009 à 23:42
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 12 April 2009
Status
Member
Last seen
16 February 2010
166
6 May 2009 à 22:06
6 May 2009 à 22:06
It can be easily done on MS Excel 2007. My macro skill is not good enough but i'll try to check it out ......
6 May 2009 à 21:22
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