Formula for shading / Patterns

  • Thread starter Thread starter Michelle
  • Start date Start date
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
 
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
 
Back
Top