Hui,
Thanks, but I guess I wasn't as clear as I should've been...I can't get it to do it for more than a single row. Basically I need to highlight any row in my spreadsheet that has the words "OPEN" or "CLOSED" in column L of that row.
I know it must be something I'm doing wrong with the L...
I need to find a way to conditionally format a range in a row based on the value of a single cell in that row.
EX: If L160="CLOSED", I'd like to get the whole range of cells to be green colored, and if L160="OPEN".
I just can't seem to work it out, any help is appreciated.
Thank you...