LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Conditional formatting ranges in VBA

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting & Protected Ranges disappear after running macro CNP Excel Discussion (Misc queries) 1 December 1st 10 10:09 PM
Conditional Formatting, Date Ranges and Rows chickalina Excel Discussion (Misc queries) 2 June 2nd 10 09:54 PM
Conditional formatting date ranges arkmpr Excel Worksheet Functions 1 January 19th 07 08:24 PM
Conditional Formatting - date ranges Angela Excel Discussion (Misc queries) 3 November 2nd 05 03:36 PM
Ranges within Conditional Formatting Ryno Excel Discussion (Misc queries) 4 December 14th 04 12:47 AM


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"