Formula for shading / Patterns

[Michelle]

Is there an Excel formula for shading a row, column or
even one celll?

Thanks!

 

[Trevor Shuttleworth]

Michelle

no. You can use Conditional Formatting as I described in my response to
your earlier post or you could set something up as a worksheet event. The
most likely candidates are Worksheet_Change or Worksheet_SelectionChange

Private Sub Worksheet_Change(ByVal Target As Range)
':
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
':
End Sub


Regards

Trevor

 

[Kent]

One Simple approach to Shade cells with patterns is to:

Select the cells you want to apply shading to.

On the Format menu, click Cells, and then click the
patterns tab.

To include a background color with the pattern, click a
color in the Cell shading box.

Click the arrow next to the Pattern box, and then click
the pattern style and color you want.
If you do not select a pattern color, the pattern is
black.

Also, you may want to look up "conditional formatting in
the Help. Then, of course, there's macro programming ...

Excel Support Technician
www.canhelpyou.com