Y
Yunus
Hi,
I have a table with
Cells A2:A150 List of Names
Cells B1:CX1: List of Duties
The Matrix: Cells B2:CX150 have Dates is them.
I have Created Conditional Formats for the Matrix as follows:
Cell Value <NOW(0) is Red
Cell Value <NOW(0) +14 is Yellow
Cell Value <NOW(0) + 42 is Orange
What I would like to achieve now, perhaps in a Separate Worksheet, when
I open the workbook daily,
3 Tables indicating the Names & Duties which are now RED, Orange and
Yellow.
I tried to use INDEX & MATCH but confusing myself, So is this a Vlookup
or a IF Function extraction?
Thanks
I have a table with
Cells A2:A150 List of Names
Cells B1:CX1: List of Duties
The Matrix: Cells B2:CX150 have Dates is them.
I have Created Conditional Formats for the Matrix as follows:
Cell Value <NOW(0) is Red
Cell Value <NOW(0) +14 is Yellow
Cell Value <NOW(0) + 42 is Orange
What I would like to achieve now, perhaps in a Separate Worksheet, when
I open the workbook daily,
3 Tables indicating the Names & Duties which are now RED, Orange and
Yellow.
I tried to use INDEX & MATCH but confusing myself, So is this a Vlookup
or a IF Function extraction?
Thanks