ExcelBanter - Conditional Formatting with range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formatting with range (https://www.excelbanter.com/excel-worksheet-functions/249858-conditional-formatting-range.html)

Conditional Formatting with range

I have a calendar and in the Friday column I want the cells to reformat if they match a range of dates located elswhere in the spreadsheet. The application is work hours have to be submitted on Friday every 2 weeks. Because these dates are constantly changing but not the day (Friday), I need a formula that will recognize the dates in the RANGE and then if it 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 be approaching this problem from the wrong angle.

K

Conditional Formatting with range

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:

I have a calendar and in the Friday column I want the cells to reformat
if they match a range of dates located elswhere in the spreadsheet. The
application is work hours have to be submitted on Friday every 2 weeks.
Because these dates are constantly changing but not the day (Friday), I
need a formula that will recognize the dates in the RANGE and then if it
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 be
approaching this problem from the wrong angle.

K

--
Keyrookie
.

Quote:

Originally Posted by Stefi (Post 906119)

Thanks Stefi,

I've tried your formula but can't get it to work. My Friday dates are located in column AF. My target dates (the dates I'm wanting to match) are located in C62:G68. I copied the target dates to a single column and tried formula but it didn't work. What am I doing wrong?

K