I meant this
Quote:
if E5<>"", F5<>"", G5<>"", H5<>"", I5<>"" IN WORKSHEET1
AND IF F5>69% IN WORKSHEET2
THEN E5 IN WORKSHEET 2 CHANGE TO RED
|
Could you please post a sample sheet with some mock-up data and expected results?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|