If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting Anomaly
I'm using the formatting paintbrush to copy a conditional format to multiple cells. The format is based on 2 conditions. The first condition turns the cell blue if the number is 1% higher than the base cell in column B. The second condition turns the cell yellow if it is 1% higher than the base cell in column B. The cells which fall in between the +1% and -1% will stay unformatted. When I copy the format with the paintbrush, the cells that should be unformatted turn a color (yellow or blue). There are external links (not to the conditional formatting) if that makes a difference. Other than that, I don't see any reason why it shouldn't work. If I go into the conditional formatting and retype the conditional format in, it works. Here is the equation.... Format 1. if cell value is greater than $B1+.01 than turn blue Format 2. if cell value is less than $B1-.01 than turn yellow I have no idea why this doesn't work when I copy it. Please HELP! -- Rutgers_Excels ------------------------------------------------------------------------ Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973 View this thread: http://www.excelforum.com/showthread...hreadid=274324 |
#2
|
|||
|
|||
I expect you want to make that $B$1
which would always compare you to the same cell. My page on Conditional Formatting is http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rutgers_Excels" wrote in message ... I'm using the formatting paintbrush to copy a conditional format to multiple cells. The format is based on 2 conditions. The first condition turns the cell blue if the number is 1% higher than the base cell in column B. The second condition turns the cell yellow if it is 1% higher than the base cell in column B. The cells which fall in between the +1% and -1% will stay unformatted. When I copy the format with the paintbrush, the cells that should be unformatted turn a color (yellow or blue). There are external links (not to the conditional formatting) if that makes a difference. Other than that, I don't see any reason why it shouldn't work. If I go into the conditional formatting and retype the conditional format in, it works. Here is the equation.... Format 1. if cell value is greater than $B1+.01 than turn blue Format 2. if cell value is less than $B1-.01 than turn yellow I have no idea why this doesn't work when I copy it. Please HELP! -- Rutgers_Excels ------------------------------------------------------------------------ Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973 View this thread: http://www.excelforum.com/showthread...hreadid=274324 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Too much conditional formatting? | LJpse | General Discussion | 1 | November 8th, 2004 01:50 AM |
Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |