Conditional Format for Multiple Sheets

[RandyD123]

I have 12 sheets that I want to apply conditional formatting across them all. I only need to make sure that any cell that has data will be an Arial 14 point Bold font across all sheets. I would like to also exclude just one sheet that I use for a "compile sheet"

Right now I am using conditional formatting for each sheet. Can I do this using VBA code instead?

 

[Joe4]

If you turn on the Macro Recorder, and record yourself applying the Conditional Formatting to one sheet, you should get most of the VBA code you need to do that part.

Then, just put it in a loop that goes through all your sheets, something like:

    Dim ws As Worksheet
    
    For Each ws In Worksheets
        If ws.Name <> "compile sheet" Then
            ws.Activate
            'conditional formatting code here
        End If
    Next ws

 

[RandyD123]

Does the "compile sheet" have to be the name of each sheet or can I use workbook instead?

 

[Joe4]

Does the "compile sheet" have to be the name of each sheet or can I use workbook instead?

I am afraid your question doesn't make much sense.
You asked how you can apply conditional formatting to all sheets except for one in VBA. Where does "workbook" come in?
Basically, you need to tell it either the sheet name or sheet index to skip over.