Hello again.
List contains the names. Range L8:L127 shows the number of days each person worked. Range M8:M127 shows the company code.
Codes are different. I need macro to check range with company codes (M8:M127) and if the cell contains text "GSF - CDC" check the L range for number of days person worked. And then if it is more than 14 days highlight that range from A to M in green
PS range L8:L127 is text.
List contains the names. Range L8:L127 shows the number of days each person worked. Range M8:M127 shows the company code.
Codes are different. I need macro to check range with company codes (M8:M127) and if the cell contains text "GSF - CDC" check the L range for number of days person worked. And then if it is more than 14 days highlight that range from A to M in green
PS range L8:L127 is text.

Last edited: