Google Sheets: Script for changing background of cell color.

[Contech]

I am very familiar with conditional formatting, however this situation presents a different kind of obstacle for me.

I need a script that will change the cell to the left,right and below etc, a different color if a condition is met without being attached to a cell number designation(A1 etc...) What I am trying to get around is having to conditionally format hundreds of time in a sheet having to do with shipping products from our warehouse. As you can see in the image attached cell A3 & cell A5 are the cells that would dictate the colors of the cells adjacent to them. This is only a partial view as there would be many more days and entries on the sheet. any other ideas on how to do this are welcome, im just trying to find a working solution. I can elaborate more if needed.

Image: https://drive.google.com/file/d/1XL5NJ5W8jLNBHJOaY7vzgMNOrJjlnl_G/view?usp=sharing

 

[Contech]

this may be a better way of explaining what im trying to do.

https://docs.google.com/spreadsheets/d/12wXJE2_C7LwAzlrq_VtL_ZeUlW_cIAeTcnOrx7TF0ws/edit?usp=sharing