This is my first time posting.
I want AB1 to highlight red if date in S1 is not blank and N1 doesnt equal AA1. Is this possible?
TIA for any help!
Jen
This is my first time posting.
I want AB1 to highlight red if date in S1 is not blank and N1 doesnt equal AA1. Is this possible?
TIA for any help!
Jen
for 2007 or 2010 excel version
Conditional Formatting
Highlight applicable range >>
AB1
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:
=AND(S1 <> "",N1 <> AA1)
Format… [Number, Font, Border, Fill] - use Fill and Colour RED
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks