Try the Attachement
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: Thursday, July 21, 2011 9:36 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ VBA Conditional Format Offset
Try :
Sub
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Natron
Envoyé : jeudi 21 juillet 2011 04:15
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ VBA Conditional Format Offset
I have multiple columns (around 140) of data
Thanks Daniel that works, but I'm still trying to wrap my head around
applying this format to various ranges on the worksheet.
My data I'm comparing is in Column D and F, E and Getc all the way
up to Column EK. Any pointers on skipping around with this formula?
Thanks again!
Natron
Try
la part de Natron
Envoyé : jeudi 21 juillet 2011 19:05
À : MS EXCEL AND VBA MACROS
Objet : Re: $$Excel-Macros$$ VBA Conditional Format Offset
Thanks Daniel that works, but I'm still trying to wrap my head around
applying this format to various ranges on the worksheet.
My data I'm comparing
I have multiple columns (around 140) of data and need to conditionally
format the data as apposed to looping through.
For instance I have the following data in column A and B.
A B
1 10
2 1
8 4
4 3
5 6
Here is basically what I'm trying to do:
If Column A has a value Greater than Column B then
