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)

Similar discussions

Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

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

32 responses
formating the pen drive
akshit -
jack4rall -

1 response
Copy rows based on a condition
Blossom83 -
ravichennai86 -

30 responses