Hi all,
So here is what I am trying to do in VBA (I'm not sure if this is possible to do in conditional formatting or if it's too complicated):
-For an example Row 5, compare the current month to the month listed in Column N (cell N5 in this case)
-If a value (date) is present/exists in any of cells H5:J5, skip to end (do nothing).
-If the same month, color the corresponding cells in Columns H:J yellow
-If the current month is past the month listed in cell N5, color the corresponding cells in Columns H:J red.
-same thing for formatting Columns K:M based on months listed in Column O.
this is for all rows 4 through 71.
I hope that all makes sense.
So here is what I am trying to do in VBA (I'm not sure if this is possible to do in conditional formatting or if it's too complicated):
-For an example Row 5, compare the current month to the month listed in Column N (cell N5 in this case)
-If a value (date) is present/exists in any of cells H5:J5, skip to end (do nothing).
-If the same month, color the corresponding cells in Columns H:J yellow
-If the current month is past the month listed in cell N5, color the corresponding cells in Columns H:J red.
-same thing for formatting Columns K:M based on months listed in Column O.
this is for all rows 4 through 71.
I hope that all makes sense.
