VBA Code to highlight or bold subtotals if not a certain value

M

mc

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
VBA to Find Word or Phrase then Highlight Entire Paragraph that Follows 5
Help VBA code - Create a table based on user input 0
use ComboBox value to select range and then use selected range tocreate a chart 3
SOS-Need to calculate number of working hours per each week of mon 2
how to find a last value in a column in excel 1
code to highlight max value in a range 2
VBA to identify the name of a point 3

Top