Did you read your description before posting?

A5B5 is the same as B5<A5

A typo or?


Gord Dibben MS Excel MVP


On Wed, 12 Dec 2007 16:34:39 -0800 (PST), Dan wrote:

Hello -

I would like to use VBA for some Condtional Formatting.

I have 2 columns, A and B. From row 5 down, I would like to have
cells in column A be Conditional Formatted.

For example:
* If A5B5 then color RED
* If B5<A5 then color GREEN
* ...and so on till the end of data in Column A.

Thanks for any assistance.
Dan