Is it possible to use conditional formatting to highlight cells based on part of a string from cells found using VLOOKUP?
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
M=Monday, TU=Tuesday, W=Wednesday, TH=Thursday, F=Friday, SA=Saturday
If “Name 1” is in A1 on sheet 1 VLOOKUP will look in the range A1:C3 on sheet 2. Then read the text in the in cells in column C then highlight only the cells for the days required on sheet 1.
Example of result returned to Sheet 1
<tbody>
</tbody>
I think I am supposed to use ISNUMBER SEARCH nested in VLOOKUP but don’t know how.
Any help is greatly appreciated.
Sheet 1
Name 1 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
Name 2 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
Name 3 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
<tbody>
</tbody>
Sheet 2
Name 1 | THFSA | |
Name 2 | TUWTHF | |
Name 3 | MTUWTHFSA |
<tbody>
</tbody>
M=Monday, TU=Tuesday, W=Wednesday, TH=Thursday, F=Friday, SA=Saturday
If “Name 1” is in A1 on sheet 1 VLOOKUP will look in the range A1:C3 on sheet 2. Then read the text in the in cells in column C then highlight only the cells for the days required on sheet 1.
Example of result returned to Sheet 1
Name 1 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
Name 2 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
Name 3 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
<tbody>
</tbody>
I think I am supposed to use ISNUMBER SEARCH nested in VLOOKUP but don’t know how.
Any help is greatly appreciated.