How do I colour ill a cell in excel with a formula?
I am trying to figure out how to automatically colour a cell in excel if my "IF" statement turns out to be negative. For example I have a list of prices in excel, and if they are $50 higher or $50 lower than the targeted price I need that to be flagged somehow in excel (preferably by filling it in with a different colour). Currently I am going through the prices manually and this just takes up too much time!! Help me! -- SLO ------------------------------------------------------------------------ SLO's Profile: http://www.excelforum.com/member.php...o&userid=35450 View this thread: http://www.excelforum.com/showthread...hreadid=552262 |
How do I colour ill a cell in excel with a formula?
Use conditional formatting under the Formatting menu.
Assuming Col A is the Targeted price and Col B is the actual price, use the following Conditional Format: Choose "Formula is" option from dropdown Enter this as the condition: =ABS($A1-$B1)50 Select the Format button and select the special format to apply (e.g. Yellow fill). -K |
How do I colour ill a cell in excel with a formula?
I forgot to mention - select column "B" before opening the Conditional
Formatting window. This will apply the formatting to the entire column. keeena wrote: Use conditional formatting under the Formatting menu. Assuming Col A is the Targeted price and Col B is the actual price, use the following Conditional Format: Choose "Formula is" option from dropdown Enter this as the condition: =ABS($A1-$B1)50 Select the Format button and select the special format to apply (e.g. Yellow fill). -K |
How do I colour ill a cell in excel with a formula?
Hi, SLO. Try using the "Conditional Formating" option in the Formating menu. 1. Select the columms where the negative values appear; 2. Go to Conditional Formating; 3. Choose the arguments for Cond.Formating the cells you chose. ..ulisses www.linearsm.com.br "SLO" escreveu: I am trying to figure out how to automatically colour a cell in excel if my "IF" statement turns out to be negative. For example I have a list of prices in excel, and if they are $50 higher or $50 lower than the targeted price I need that to be flagged somehow in excel (preferably by filling it in with a different colour). Currently I am going through the prices manually and this just takes up too much time!! Help me! -- SLO ------------------------------------------------------------------------ SLO's Profile: http://www.excelforum.com/member.php...o&userid=35450 View this thread: http://www.excelforum.com/showthread...hreadid=552262 |
How do I colour ill a cell in excel with a formula?
Thanx Keena, I tried this and its not doing anything. I used a target price of $400.00 and an acutal price of $500 - and nothing happened - super frustrating! keeena Wrote: I forgot to mention - select column "B" before opening the Conditional Formatting window. This will apply the formatting to the entire column. keeena wrote: Use conditional formatting under the Formatting menu. Assuming Col A is the Targeted price and Col B is the actual price, use the following Conditional Format: Choose "Formula is" option from dropdown Enter this as the condition: =ABS($A1-$B1)50 Select the Format button and select the special format to apply (e.g. Yellow fill). -K -- SLO ------------------------------------------------------------------------ SLO's Profile: http://www.excelforum.com/member.php...o&userid=35450 View this thread: http://www.excelforum.com/showthread...hreadid=552262 |
How do I colour ill a cell in excel with a formula?
Something is incorrect with how you are applying the conditional
formatting. Can you tell me more about the sheet layout? e.g. what are the cells/columns/rows you want to compare? Is there a header, etc... That way I can give more explicit instructions. SLO wrote: Thanx Keena, I tried this and its not doing anything. I used a target price of $400.00 and an acutal price of $500 - and nothing happened - super frustrating! -- SLO |
All times are GMT +1. The time now is 02:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com