I presently use three separate conditional formatting statements to highlight the exact same areas the same color if a cell is blank, if it has an "n" in it or if it has an "N" in it. I suspect there is probably a good way to use an OR operator and/or something like using ucase or the like.
Please enlighten me!
Use the following formula (substituting for your cell/range as needed) in the 'Use a formula to determine which cells to format' field.
=IF(OR(A1="",A1="n",A1="N"),TRUE)
*edit: realized I had 1 too many end parentheses
Last edited by Shazardred; 10-28-2015 at 03:01 PM.
I selected column A for the conditional formatting.
Conditional Formatting, New Rule, Use formula and enter this formula. "n" will cover both upper and lower case n.
Formula:
Please Login or Register to view this content.
Select the formatting that you want.
<---------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
Thank-you.
I suspect that OR can only take two argument the, correct? Also the fact that the lower case handles both upper and lower is a pleasant surprise!
OR isn't limited to two arguments. It can take up to 255 arguments.
Thanks - that means I must have messed up somewhere else something awful, but now I know where to look to start tracking it down. Is it correct as:
(with the "=" added for the Conditional Formatting example)?
Please Login or Register to view this content.
That's the way it goes. Separate each condition with a comma and all the conditions are surrounded by ()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks