Angled Cell Fill

[Socrates055]

I have an excel sheet with all cells the same size (20 pixel rows and columns). I have top borders on range C2:Z2 and F18:AJ18 and I inserted lines to connect the end points using alt key so the lines connect in the corner of the cell. For the cells that get cut by the straight line (that's on an angle not 45 deg.) is it possible to shade only the part of the cell that is inside the shape?

I am using the excel sheet to make a scale drawing (plan view) of where each concrete truck pours on a bridge deck.

 

[dreid1011]

Have you tried inserting a shape and editing the corner points to match up with the range you have identified? You can change the fill color, pattern, opacity, etc with the shape. I do not believe the fill tool works the way you want.