Conditional Formatting
Posted by Al Polan on May 17, 2001 12:08 PM
I am doing a conditional format comparing the number in one cell against another cell, if cell A1 is greater than the amount in cell B1 the number in A1 will be red, if it is less it will be Green, if it is the same it will be Blue. Everything works fine but what I need to know is how can I fill down the rest of the cells and have the conditional formatting recognize all of the cell numbers on the way down, as it is now if I fill the cells down the Conditional Formatting only recognizes cell A1 and does not change cell numbers on the way down. Thanks to anyone who can help.
Posted by Barrie Davidson on May 17, 2001 12:12 PM
Before filling the cells down, check to make sure that the conditional formatting is not using absolute references (i.e., $A$1 should be changed to A1). This sounds like your problem, if not let me know and I'll try and help out more.
Barrie.
Posted by Al Polan on May 17, 2001 12:53 PM
:Barrie
Barrie; I tried that and the number changed from red (which it should be) to green, and then I tried to fill down but it only kept the same cell as the original cell.
Posted by Kevin James on May 17, 2001 12:59 PM
Al,
Please forgive me if this insults your intelligence, but you ARE using the Paint Brush icon to copy the format, right?
Kevin
Posted by Al Polan on May 17, 2001 1:11 PM
Kevin; I cannot even find the paint brush, I just found out that is what I was to use when performing this function. How do I find It???
Thanks Al.
Posted by Barrie Davidson on May 17, 2001 1:24 PM
Try copying cell A1, selecting the range you want conditionally formatted, and then Edit|PasteSpecial|Formats (from the menu bar).
This should do the trick for you.
Barrie
Posted by Al Polan on May 17, 2001 1:48 PM
Kevin; I found the paint brush but to no avail, even when using the paint brush to copy the format the values in conditional formatting remain the same as the original conditional formatted cell. Al Polan
Posted by Aladin Akyurek on May 17, 2001 2:14 PM
Lets say you have the following data, occupying a1:b4.
{1,2;2,6;4,3;5,5}
Activate cell A1, activate Format|Conditional Formatting. Choose for Condition 1 Formula Is and type: =A1>B1 then activate Format button and select Red on Font tab.
Activate Add button, Choose for Condition 2 Formula Is and type: =A1 < B1 then activate Format button and select Green on Font tab.
Activate Add button, Choose for Condition 3 Formula Is and type:
=A1=B1 then activate Format button and select Blue on Font tab.
Click OK. While still in A1, go to the Icon bar and hit the Format Painter icon. Now select the cells A2 to A4.
Hope this helps.
Aladin
Posted by Al Polan on May 17, 2001 6:31 PM
Aladin; Thank you very much it worked perfectly.
