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
Copy rows based on a condition
Blossom83 -
ravichennai86 -

30 responses
Copy rows to new sheets if condition is met
I.Gal -
vcoolio -

7 responses
Conditional Formatting based on two cell values
JamesA82 -
Mazzaropi -

3 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses