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,
timmlaww
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,
timmlaww