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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,102,292
Messages
5,485,978
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top