Conditional Formating Format Painter

  • Thread starter Thread starter hotherps
  • Start date Start date
H

hotherps

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
 
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
 
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) =C1>F1 -> 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
 
Back
Top