Select column A by clicking on the A at the top. Do
Format--Conditional Formatting--Formula is--=A1D1--Format select
red. No VBA needed. If you really want VBA just turn on the macro
recorder and do the steps above.

Chillygoose < wrote:
I need help changing the cell color of excel reports I receive.

when cell A1:A? cell D1:D? change cell color red

I cant use conditional formating because you have to input cell by
cell, it doesn't do a range.

I need to apply this macro/VBA to excel 2003 worksheets I receive and
apply to the whole document. I think it would be VBA, which I am not
very good with.

Any help is greatly appreciated.

Chilly


---
Message posted from http://www.ExcelForum.com/