Thanks Montrey, I tried to enter this if(and(rowvalue=1,F9=J9) as a formula in conditional formating and nothing happens. The F9 value is to be tested on each row (not static F9)
Basically, if a row value in H col = 100% and the same row value in F Col = value in J9 (static) then highlight value in pink background color.
How do I write it so the F9 value is relative to each row
Thanks SirJB7, would not function but after some playing around I managed to get your formula to work. Must have had previous CF on the row stopping it from working possibly?. Looks good now, that's awesome!