Conditional formatting equal values 2007
Phippsy,
The solution for your first #2 is to have F2 be the active cell when you apply the CF.
The solution to loosing the bottom border is to use
=AND(MOD(ROW(),2)=0,F1=F2)
as your first CF, with shading and border
then use the other two (just border, and just shading) as your second and third CFs.
A similar solution will work for your second #2 - for example
=AND(MOD(ROW(),2)=0, K2 = "Service")
HTH,
Bernie
MS Excel MVP
"Phippsy" wrote in message
...
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.
|