LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MC MC is offline
external usenet poster
 
Posts: 29
Default VBA Code to highlight or bold subtotals if not a certain value

Hi,

is there VBA Code to highlight or bold subtotals if each total is not a
certain value? For example, I have a spreadsheet of data listing all
resource names for x number of projects with number of hours per month
(October 2009 to Dec 2010). I have no problems subtotaling at different
resource name. I want to highlight if the number of hours exceed 100.

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When using subtotals in Excel, how do you bold the dollar amount? guntergal Excel Discussion (Misc queries) 1 May 11th 10 09:36 PM
Bold Subtotals Teddy-B Excel Discussion (Misc queries) 3 April 11th 07 07:18 PM
How do I bold just the totals when using Subtotals? Victor Excel Worksheet Functions 2 March 20th 07 04:15 PM
Excel subtotal function- put subtotals in bold text EPMMGR06 Excel Discussion (Misc queries) 2 August 31st 06 05:47 PM
How to bold/highlight data point in chart HankGreene Charts and Charting in Excel 2 August 15th 06 06:08 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"