Conditional Formatting (more than 3) in Excel [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

2 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
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"
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Hi, Thanks for the reply.

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
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
It can be easily done on MS Excel 2007. My macro skill is not good enough but i'll try to check it out ......





Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!