I want to use the conditional formatting so that if any of the cells E5 to I5 in worksheet 1 has something (the person needs to mark one of the cells) and the F5 in worksheet 2 is less that 69% then the cell E5 in worksheet 2 change to red, but if in any of the cells E5 to I5 has something (the person marked one) but F5 is more that 69% the nothing happens.
so it will be something like this (it's not a formula I am trying to write in excel language so you understand)
if E5<>"", F5<>"", G5<>"", H5<>"", I5<>"" IN WORKSHEET1
AND IF F5>69% IN WORKSHEET2
THEN E5 IN WORKSHEET 2 CHANGE TO RED
THANKS!
|