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

Cell formula help?
 

Try conditional formatting. See
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brad" wrote in message
...
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