Cell formula help?
Hi All,
I've got the following formula in cells on a worksheet...
=IF($E4=AU2,"PO",IF(($E4+18)=AU2,"IC",""))
Obviously this gives me "PO" and "IC" 18 cells apart when E4=AU2. What I
would now like to do is somehow colour the cells between these 2 values.
Does anybody have any suggestions?
TIA
BC
|