I'm not an expert at all but I'm stumped and have search the forum for the answer and can't find a match.
In my attached example, I would like to highlight an entire row blue if the number in column A is either 12, 23, or 26. I'm sure this is simple to most of you but I'm missing something. I've attached a sample sheet and have removed all rules. Thank you in advance for your help.
sample conditional formatting.xlsx
for 2007 or 2010 excel version
Conditional Formatting
Highlight applicable range >>
A:A
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=OR(A1=12, A1=23, A1=26)
Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
You can achieve this by a macro or a simple conditional formatting.
I have added both in the attached file
Plz see attached file as well.
Please Login or Register to view this content.
If I've been of help, plz add reputation.
Thank you for your help! works perfect!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks