Hi

I want to do 3 lots of conditional formatting.
1. Every other row has a bottom border - done using the =MOD(ROW(),2)=0
formula - this works fine
2. In one column a cell needs to be in red if it is the same as the cell
above. - selected the column and used =F1=F2 but whichever way round i enter
this it is always the top one which is red not the bottom one. Also loose the
bottom border formatting from condition 1
2. Another column has text in red if it says 'Service' - straight forward
apart from again losing the bottom border.