Search : in
By :

Conditional Formatting (more than 3) in Excel

Last answer on May 7, 2009 3:06:32 am BST steve1000, on May 5, 2009 2:04:23 am BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Conditional Formatting (more than 3) in Excel » in :
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Unlimited Conditional Formatting ShowUnlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Download ABC Amber Text Converter Show
Download AVStoDVD ShowIn most cases, programs offer to convert DVD to other formats more standardized and less bulky. But it is rare to find tools that are the opposite. AVStoDVD is a flexible tool for converting various video formats to DVD format. Advantage The video...
Download Speechi Light Show
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
MKV format (Matroska Video) ShowMKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid,...
Mini-DIN connector Show4-pin Mini-DIN connector The 4-pin Mini-DIN connector is used for transmitting analog video in S-Video format: More and more graphics cards these days have an S-Video socket built in, so that the computer's output can be viewed on a television...
Ask your question Reply

1

mubashir aziz, on May 6, 2009 4:42:10 am BST
  • +1

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"
Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

2

steve1000, on May 7, 2009 2:22:12 am BST

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

   
Reply to steve1000

3

 mubashir aziz, on May 7, 2009 3:06:32 am BST

It can be easily done on MS Excel 2007. My macro skill is not good enough but i'll try to check it out ......





Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz
Ask your question Reply
They need your help