Hi there, I'm having an issue with a little project I'm working on. I need to highlight certain rows based on the values in one particular column -- the tricky part being that it's based on values in the previous and next column. More specifically, I've got numerical values in column W, and I need to highlight each row where the value in column W is greater than or equal to 0.3, OR the values in the two surrounding rows (same column) are equal to or greater than 0.3. I've got part of it -- I made it so that it highlights the row the value in that row or the next one meet the criteria, but I don't know how to reference the previous row. Here's what I have so far (under "use a formula to determine what cells to format):
=OR($W1>=0.3,$W2>=0.3)
Since W0 isn't a row, how do I reference the previous row?
Thanks!
Bookmarks