I want the names in column B of my spread sheet to highlight either red or
yellow based on the value of the cell in column L, but with conditional
formatting you can only format based on the value of the cell you are
formatting, as far as i can tell.