Inked-Screenshot-2021-10-19-010840-LI.jpg
Screenshot-2021-10-19-010922.png
Screenshot-2021-10-19-010945.png
Hi guys
I would like to copy colors format ( red if left day range contains "s" and green if contains "h") . I ve managed to find a formula but can autofill it with relevant cells ( gotta put it manually every time - sooo time consuming ) . Is there a way to autofill it ? Like scrolling it down with a mouse but having the formula changed so that it matches cells on the left? Or different formula?
I can copy format with painter or scroll it down with formatting only but it stay the same .
Bookmarks