Conditional Formatting with range

  • Thread starter Thread starter Keyrookie
  • Start date Start date
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.
 
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:
 
Back
Top