Conditional formatting equal values 2007

[Phippsy]

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.

 

[Bernie Deitrick]

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]

Great thanks

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