I have a column that should compare data to a column next to it and
color red green or black depening on the result of the expression. I
was using the conditional formatting front end. I got an error that
said for multiple conditions on the same cell you can not use the
format painter to copy down the rest of the column. You have to do it
one cell at a time??

I can't believe I am going to have to code something so simple.

Is there a way around this?

Thanks


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