Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Conditional Formatting
Resolved · Medium Priority · Version 2007
Reply Tue 29 Mar 2011, 12:30
Edited on Tue 29 Mar 2011, 15:06Delegate Paul said...
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
For upcoming training course dates see: Pricing & availability
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
Tue 5 Apr 2011: Automatically marked as resolved.
|