i am trying to CONDITIONAL FORMAT RANGE OF CELLS BASED ON ANOTHER RANGE OF CELLS I.E IF THEY MATCH (CELL FOR CELL) no format if one cell different to its counterpart formatting applied

I have achieved this in office 2007's excel which works as i want however the pc this program is destined for runs on excel 2003 so the conditional formatting doesn't work

so im looking to create vba code for it but cant get my head around converting the working formula into code

NOT (E8:R31=E54:R77) SETS OFF A CELL FILL

thanks in advance to anyone who can help out

From memory (of Excel 2003 and below) if you put the Conditional Format in the first cell and use the Format Painter on all subsequent cells it sould work.

Try the Conditional Format:
=IF(E8<E54,1,0)
...and format accordingly

NB: You may have to re-edit the Conditional Format formula to remove any $ automatically put in there by Excel - e.g. change "=IF($E$8<$E$54,1,0)" to read as above.

When you use the format painter on cells E8 thru to R31, it should increment the E8 and E54 in the Conditional Format formula for each cell individually (I think).

NB2: If you do this in Excel 2007, it will just apply the same Conditional Format across the range you selected - gives the same result in Excel 2007, but may not translate back to 2003 properly.

Hi,

To do this, create a new workbook and enter this into the workbook section in the vb editor:

Code: