Conditional Formatting with range

K

Keyrookie

I have a calendar and in the Friday column I want the cells to reforma
if they match a range of dates located elswhere in the spreadsheet. Th
application is work hours have to be submitted on Friday every 2 weeks
Because these dates are constantly changing but not the day (Friday),
need a formula that will recognize the dates in the RANGE and then if i
matches or equals the date in the Friday COLUMN I need it to reformat.

If there is another way to achieve this result I'm all ears. I may b
approaching this problem from the wrong angle.
 
S

Stefi

If your Friday dates are in, say, column E then apply this formula in CF:

=ISNUMBER(MATCH(E2,I:I,0))

--
Regards!
Stefi



„Keyrookie†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need formular to use with dates 7
Conditional Formatting Date Range 2
Conditional Formatting with Icon Sets 0
Conditional formatting on a dynamic range - workaround 1
Conditional Formatting (Dates) 3
How to format cells to show dates as the week-ending date of that 1
Comparison of columns using Conditional Formatting 3
=month() function equivalent for fiscal calendar 1

Top