I have a column I am trying to conditionally format based on 3 columns next to it. But everytime I try and do it only 1 or 2 work and highlight. I already have a lot of data so dont want to delete any so how do I get it so that for example if N2=1 turns green if O2=1 Turn Blue if P2=1 Turn red and i want it so if i was in L40 that its still N40 etc