View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad[_22_] Brad[_22_] is offline
external usenet poster
 
Posts: 8
Default 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