Apply conditional formatting to all rows in worksheet

toant

New Member
Joined
Apr 24, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows
I have values in column A that I would like to make a conditional formatting for. If the value in Column A is less than the Sum of column D, E, F in the same row then cell A3 will be red and green if it is greater. I want to apply this to all rows down the list.

This is just a sample for simplicity but the actual data is actually more.

I just want to find a quick way to apply to all the data instead of having to apply the condition one at a time to each row.

Thanks.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

toant

New Member
Joined
Apr 24, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows
I have values in column A that I would like to make a conditional formatting for. If the value in Column A is less than the Sum of column D, E, F in the same row then cell A3 will be red and green if it is greater. I want to apply this to all rows down the list.

This is just a sample for simplicity but the actual data is actually more.

I just want to find a quick way to apply to all the data instead of having to apply the condition one at a time to each row.

Thanks.

Sample Data uploaded
 

Attachments

  • Demand.png
    Demand.png
    28.2 KB · Views: 4

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,666
Office Version
  1. 365
Platform
  1. Windows
How about
+Fluff 1.xlsm
ABCDEF
2Amount needed
33315
47054
56600
69021
7
8
9
10
Result
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A3:A10Expression=A3>SUM($D3:$F3)textNO
A3:A10Expression=AND(A3<>"",A3<SUM($D3:$F3))textNO
 
Solution

Forum statistics

Threads
1,141,863
Messages
5,709,063
Members
421,611
Latest member
Lisa W

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top