View Single Post
 
Old 06-08-2015, 07:19 AM
piper7971 piper7971 is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

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!
Reply With Quote