Hallo friends,
I would like to ask you for help to set up formula in Conditional formating for cells I think base on "HLOOKUP".
I have in the row 58 names of days (Array G58:AK58) of the week generated base on the date below (row 59). As I change the date/month in the cell G59 (first day of the month), in the array G58:AK58 will automatically change names of days of the week for whole month. My goal is to change base on the name of the day Saturday/Sunday with Conditional formating the background of cells in the whole table below Saturdays (e.g. orange) and Sundays (e.g. red). Last row of the table is "80".
Please could you help me with this issue.
Thank you for your soon response.
I would like to ask you for help to set up formula in Conditional formating for cells I think base on "HLOOKUP".
I have in the row 58 names of days (Array G58:AK58) of the week generated base on the date below (row 59). As I change the date/month in the cell G59 (first day of the month), in the array G58:AK58 will automatically change names of days of the week for whole month. My goal is to change base on the name of the day Saturday/Sunday with Conditional formating the background of cells in the whole table below Saturdays (e.g. orange) and Sundays (e.g. red). Last row of the table is "80".
Please could you help me with this issue.
Thank you for your soon response.