Conditional Formatting

  • Thread starter Thread starter George
  • Start date Start date
G

George

I have a spread sheet that I enter vacation dates for my
personnel. What we have is about 15 different dates that
if entered I would like the cell to turn yellow to get my
attention. I tried conditional formatting and that works
but limited to three conditions. How can I add all the
dates to one condition?

IE: If cell is equal to: 2/7 - 5/6 - 6/8 - 9/23 etc.

George
 
George said:
I have a spread sheet that I enter vacation dates for my
personnel. What we have is about 15 different dates that
if entered I would like the cell to turn yellow to get my
attention. I tried conditional formatting and that works
but limited to three conditions. How can I add all the
dates to one condition?

IE: If cell is equal to: 2/7 - 5/6 - 6/8 - 9/23 etc.

George
Click to expand...

Two approaches.

Either:
Make a list of your dates somewhere in the spreadsheet, say in
Sheet2!A1:A15. Then use the MATCH function in your conditional format
formula to see if the date finds a match in this list; this returns a number
if a match is found or #N/A if not.
=ISNUMBER(MATCH(A1,Sheet2!A1:A15,0))

Or:
Use the OR function in your conditional format formula.
=OR(A1=x,A1=y,A1=z,........)

The problem you may face is that 2/7, 5/6 and so on are not dates. Dates
MUST contain a year.
 
Thanks - Will give it a try
-----Original Message-----


Two approaches.

Either:
Make a list of your dates somewhere in the spreadsheet, say in
Sheet2!A1:A15. Then use the MATCH function in your conditional format
formula to see if the date finds a match in this list; this returns a number
if a match is found or #N/A if not.
=ISNUMBER(MATCH(A1,Sheet2!A1:A15,0))

Or:
Use the OR function in your conditional format formula.
=OR(A1=x,A1=y,A1=z,........)

The problem you may face is that 2/7, 5/6 and so on are not dates. Dates
MUST contain a year.


.
Click to expand...
 
Back
Top