1. 

   Emm
   

   Member
   Joined: Dec '12
   Posts: 1

   Just wondering if anyone can help - I cant seem to work out how to apply conditional formatting to the entire workbook as opposed to the sheet that I am currently working on....

   Posted 5 months ago #
2. 

   scottyg
   

   Member
   Joined: Dec '12
   Posts: 60

   I am not an MVP, but you could use vba to cycle through the sheets and apply conditional formating...

   For each sheet in workbook
    With Range("$R39:$R" & LastRow)
           .Select
           .FormatConditions.Delete               'remove this line if you wish
           .FormatConditions.Add Type:=xlExpression, Formula1:="=COUNTIF($R39,""?*"")"
           .FormatConditions(1).Interior.PatternColorIndex = xlAutomatic
           .FormatConditions(1).Interior.ColorIndex = 3
           .FormatConditions(1).Interior.TintAndShade = 0
           .FormatConditions.Add Type:=xlExpression, Formula1:="=COUNTIF($R39,"">0"")"
           .FormatConditions(2).Interior.PatternColorIndex = xlAutomatic
           .FormatConditions(2).Interior.ColorIndex = 3
           .FormatConditions(2).Interior.TintAndShade = 0
           End With
   Next Sheet

   Posted 4 months ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums