Conditional Formatting Help

Can you rearrange the data so that the hours are in columns? If so, you can create an additional column with a formula like "=if([Needed Machine Hours]1>[Current Mechanical/Labor Hrs Incl Eff]1,"overloaded"," ") and then set up a conditional format to highlight the "Needed Machine Hours" column if the new column includes "overloaded". Hope that helps!

I can't think of a way to get it to work with only the two rows that you show.  Maybe a row (Row 1 for this example) could be added in which a formula could be placed to evaluate the values in the column like the following:

=IF([NEEDED MACHINE HRS] > [CURRENT MECH...], "YES", IF([NEEDED MACHINE HRS] = [CURRENT MECH...], "AT CAPACITY", ""))

You could then add conditional formats for each column to highlight that cell in Row 1 like the following:

"If Column 1 is equal to 'YES' then apply this format to the Column 1 column."

You would have to clone this format and adjust it for each column and if you wanted to use the "at capacity" to highlight the cell a different color, more formats would have to be set up to do that.