Paul has attended:
Excel Advanced course
Conditional Formatting
I am looking to format a cell colour (B2) if a different cell (A2)contains the word "International". The entry in A2 is based on several possible entries, of which there are 3 varieties that contain the word "International": "Junior International", "U23 International" or "Senior International".
=OR($H1="Junior International",$H1="U23 International",$H1="Senior International")
I have tried usign the above formula to solve this but for some reason the "Senior International" one doesnt't work - works fine for the other two.
Any ideas why this is happening?
Many thanks
RE: Conditional Formatting
Hi Paul,
Thank you for your question.
If you create a new rule using 'Formula is' and type the following:
=SEARCH("international",D6)
Replace D6 with the appropriate cell.
This should be the equivalent to contains International.
Regards
Simon
