Previous Topic Next Topic

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.

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)
0

Similar discussions

Disable a cell in excel using VB code
Jinto -
TrowaD -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
Accidental formating
Min Thu Moe Moe -
BunoCS -

1 response
pendrive formating
Sailesh Giri -
Ambucias -

2 responses
Conditional formating of row based on other cells
Bitbull -
TrowaD -

1 response