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!
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!