SUMIF and highlight row

marshy3300

Board Regular
Joined
Aug 17, 2014
Messages
59
Howdy and thanks!

I have a table of data. I want to be able to highlight the row based off criteria.
G2 contains a total (200)
H2 contains how many items used (115)
I2 contains how many items remaining (50)

These aren't the actual but bear with me

Highlight (orange) criteria for the row "if H2 less than G2"
Highlight (red) criteria for the row "if I2 + H2 less the G2"

I could use conditional formating but it becomes different files so Macro is more suitable.
Also i need it to do all the rows (not just row 2!) which changes lengths.

Thanks again!
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,100,184
Messages
5,473,004
Members
406,843
Latest member
David_Welland

This Week's Hot Topics

Top