xlhelp15
Board Regular
- Joined
- Sep 12, 2014
- Messages
- 115
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hello Experts,
I need your precious solution through VBA for the below query.
I need to match these days in a row wise with the Goal set for the resources and highlight background color if that respective day is lesser than the Goal.
for eg,
Row1 :
Goal : 40 ;
Column 08/01/2018 : 45
Column 08/02/2018 : 60
Column 08/03/2018 : 56
Column 08/06/2018 : 66
Column 08/07/2018 : 0
Column 08/08/2018 : 45
like wise till end of row of GOAL.
Goal 8/1/2018 8/2/2018 8/3/2018 8/6/2018 8/7/2018 8/8/2018
40 45 60 56 66 0 45
50 61 68 77 60 0 60
50 58 58 51 51 33 0
50 54 52 52 61 0 58
50 55 55 51 65 0 60
50 52 50 54 55 0 55
50 33 44 36 47 0 44
50 55 48 42 64 0 42
I need your precious solution through VBA for the below query.
I need to match these days in a row wise with the Goal set for the resources and highlight background color if that respective day is lesser than the Goal.
for eg,
Row1 :
Goal : 40 ;
Column 08/01/2018 : 45
Column 08/02/2018 : 60
Column 08/03/2018 : 56
Column 08/06/2018 : 66
Column 08/07/2018 : 0
Column 08/08/2018 : 45
like wise till end of row of GOAL.
Goal 8/1/2018 8/2/2018 8/3/2018 8/6/2018 8/7/2018 8/8/2018
40 45 60 56 66 0 45
50 61 68 77 60 0 60
50 58 58 51 51 33 0
50 54 52 52 61 0 58
50 55 55 51 65 0 60
50 52 50 54 55 0 55
50 33 44 36 47 0 44
50 55 48 42 64 0 42