I am in the "New Formatting Rule" window, trying to create a new rule to format a cell with "Specific Text".
The question is, what do I type in, if I want more than one condition. For example if cell contains YES or OK.
Thank you
I am in the "New Formatting Rule" window, trying to create a new rule to format a cell with "Specific Text".
The question is, what do I type in, if I want more than one condition. For example if cell contains YES or OK.
Thank you
You haven't supplied sufficient information to give you a good answer. There are a couple of places that you might be in in the Conditional Formatting.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Create a 2nd (identical) rule, the 1st rule for Yes and the 2nd rule for OK
OR
use the "Use Formula" rule woth =OR(A1="Yes",A1="OK")
OR
use Data Validation to ensure they only use "Yes"
Last edited by FDibbins; 11-08-2014 at 11:30 PM. Reason: fixed a typo
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks