Hello, I was hoping someone could help me with a conditional formatting question in Excel 2007.
A little background: once a week we use some third party software to pull data from our database and create an inventory report in Excel. This report has multiple lines for each item in inventory and followed by totals on every 15th row. This sheet will generally be about 10,000 rows long.
I tried to color code this report to make it easier on myself to quickly scan through by highlighting the relevant columns and conditional formatting based on numerical ranges (i.e. red if less than or equal to zero, yellow from 0 to 10, red if greater). The problem is that this highlights a lot more than what i need and makes it even more difficult to scan through quickly.
So what i ended up doing was to highlight every 15th row using a formula in conditional formatting [=AND(MOD((ROW()-1),15)=0) --ROW()-1 because the first row is headings]. This highlights just the totals on every 15th row, but the problem is, now i can't figure out how to get the value of each cell to format based on numerical ranges.
Is something like this even possible?
Thanks in advance for all of your help.
Summary: I want to highlight every 15th row of data red if <= 0, yellow if between 0 and 10, and green if >= 10.
Bookmarks