Apply Conditional Format to all sheets in same workbook

  • Thread starter Thread starter Der Musensohn
  • Start date Start date
D

Der Musensohn

Is there a way to apply a conditional rule to all of the worksheets in a
workbook? In other words, the cell range and format is the same for each
sheet but I'd prefer not to create the rule for 40 pages.

Thank you in advance.
 
A CF is a format like any other format. Create one page and then copy and
paste to the rest of the pages...
 
Thank you Jim. The problem is that I already have individual data on each
worksheet. Specifically what I'm trying to do is hide all zeros from each
page for a specific cell range. I had simply formatted all zeros to have a
white font color. If you know of a macro or formatting code of some sort I
have some experience working with codes. I'd need to know where to paste it
and than I can make specifice reference changes after that.

Thanks.
 
Sub white_zero()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
For Each c In WS.Range("A1:B20")
If c.Value = 0 Then
c.Font.ColorIndex = 2
End If
Next c
Next WS
End Sub


Gord Dibben MS Excel MVP
 
Got it. Thanks Gord.

Gord Dibben said:
Sub white_zero()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
For Each c In WS.Range("A1:B20")
If c.Value = 0 Then
c.Font.ColorIndex = 2
End If
Next c
Next WS
End Sub


Gord Dibben MS Excel MVP




.
Click to expand...
 
Back
Top