Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 Last edited by smokey4smokey : February 24th 11 at 03:57 PM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting & Protected Ranges disappear after running macro | Excel Discussion (Misc queries) | |||
Conditional Formatting, Date Ranges and Rows | Excel Discussion (Misc queries) | |||
Conditional formatting date ranges | Excel Worksheet Functions | |||
Conditional Formatting - date ranges | Excel Discussion (Misc queries) | |||
Ranges within Conditional Formatting | Excel Discussion (Misc queries) |