Conditional Formating Format Painter
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/ |
Conditional Formating Format Painter
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/ |
Conditional Formating Format Painter
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/ |
Conditional Formating Format Painter
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/ |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com