shade one cell that will shade multiple cells

[Walt]

I want to shade one cell that would go into other cell by it's self

 

[Jim Thomlinson]

Not easy to do. You will require custom VBA code to do that. Are you Ok with
macros?