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/

Hi
can you post your conditions. This may help to provide a solution to
you

Frank

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/

If column c column F then font = red
If column c < column F then pattern = green
If column c = column F then no format

I need to apply this to a range of cells in column c.

THanks


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

Hi
try the following:
- select all cells in column C for which you want to apply your
conditional format
- goto 'contional format' and enter the following formulas
a) =C1F1 - choose format 'red'
b) =C1<F1 - choose format 'green'

change C1 to the top cell of your column selection (if it does not
start with C1)

Frank

If column c column F then font = red
If column c < column F then pattern = green
If column c = column F then no format

I need to apply this to a range of cells in column c.

THanks


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