Conditional Formatting - Apply Cell Style if a column cell is "string1" or "string2"
I'm trying to find how to get conditional formatting to apply a cell style if the cell contains either "string1" or "string2" (both are text values). I just can't seem to get a single conditional formatting rule to handle formatting for both text strings, and 2 single conditional formatting rules for one or the either term will end up formatting all the cells.
Any help appreciated!
Welcome to the Forum Tunnel_Snakes!
There are two ways to do this. The way you tried using two rules should work, and should not format all cells. I cannot tell you why that didn't work without seeing your file and what you did.
The other way is to use a single rule that uses "Use a formula to determine which cells to format" where the formula is
Formula:
Please Login or Register to view this content.
where A1 is the upper-left cell of the range you want to format.
If you are still having trouble it will help to attach your file with any private data removed. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Re: Conditional Formatting - Apply Cell Style if a column cell is "string1" or "string2"
This works as I needed it! (I also had another instance where I wanted to format any cells in a column where the values weren't one of those 2 strings, so I just wrapped the code from above in aoperator
Please Login or Register to view this content.
Glad it helped! Thanks for the rep, and thanks for marking your thread Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks