Conditional Formatting Help

Laura

See Screenshot Example Please

Goal: to compare cells in 2 rows across columns.

All numbers in both these rows are based off formulas.

I want the cell in row "needed machine hrs" (column 1) to turn RED,

IF the number is greater than the number in the cell directly below it, in row "Current Machine/Labor Hrs" (column 1).

Is this possible?

Thanks in advance for any help or suggestions

Find more posts tagged with

Sheets

Formulas

Reports

Conditional Formatting

Comments

Matt Hagler

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!

Laura

That was my first thought as well but its not my sheet to rearrange, unfortunately.

Any other suggestions, without rearranging the sheet?

Matt Hagler

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.

Matt Hagler

You could even set up a notification that would trip when the "Overloaded?" column is not blank by using the example below.

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…