Condition formating

Closed

Raj - Feb 17, 2010 at 01:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 17, 2010 at 06:53 AM

Hello,

I need to condition format cell, if the word in that cell is similar to the word in another cell which has many word.

For example: If cell A1 contains USD, AUD,HKD AND SGD. then if we input USD in cell B2, it should change format.

Condition formating
Available memory less than 15mb condition zero - Guide
If condition in excel - Guide
Your phone is optimal condition meaning - Guide
Excel copy value if condition met ✓ - Excel Forum
Excel clear cell contents based on condition ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2010 at 06:53 AM

In conditional formatting use this formula

=FIND($B1, $A1,1)

Similar discussions

Merge rows if it meets criteria in Excel

Disable a cell in excel using VB code

How to copy a data from one sheet to another, when specific criteria is met

How to enter a row when an "if condition" is met

Leave Value unchanged if false

Similar discussions

Subscribe To Our Newsletter!