Help with conditional formatting in Excel 2010
Hi
I have found setting conditional formatting the way I want in Excel 2003 quite easy but Im getting tied up in knots trying to achieve the same thing in Excel 2010. Simply put, I want the fill colour of a row to change depending on the text value of column A in that row. I have a data set spanning columns A to J and rows 3 to 50 Col A will contain the criteria text PAID or UNPAID or CHECK as required So if A3 says €śPAID€ť then A3 to J3 has a blue fill, or if A3 says €śUNPAID€ť then A3 to J3 has a RED fill or if A3 says €śCheck€ť then A3 to J3 has a green fill and I want this to continue down through the rows according to the text in col A. I hope this is clear. Ive tried every which way but have got stuck and would greatly value your input. Thanks for your time. Ian |
Help with conditional formatting in Excel 2010
Ian R was thinking very hard :
Hi I have found setting conditional formatting the way I want in Excel 2003 quite easy but Im getting tied up in knots trying to achieve the same thing in Excel 2010. Simply put, I want the fill colour of a row to change depending on the text value of column A in that row. I have a data set spanning columns A to J and rows 3 to 50 Col A will contain the criteria text PAID or UNPAID or CHECK as required So if A3 says €śPAID€ť then A3 to J3 has a blue fill, or if A3 says €śUNPAID€ť then A3 to J3 has a RED fill or if A3 says €śCheck€ť then A3 to J3 has a green fill and I want this to continue down through the rows according to the text in col A. I hope this is clear. Ive tried every which way but have got stuck and would greatly value your input. Thanks for your time. Ian So what you want to do is set up 3 conditions. The 1st condition to evaluate 'TRUE' wins! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Help with conditional formatting in Excel 2010
"GS" wrote in message ... So what you want to do is set up 3 conditions. The 1st condition to evaluate 'TRUE' wins! -- Garry =============== Hi Garry Thanks for replying. I have set up the 3 conditions which work fine but only in Col A. The formatting is not being applied across the row from Col A thru to J. This is where I'm stuck as I'm not sure where I'm going wrong. Do you have any suggestions on what I can check to see why it not happening in the other columns? Thanks again for your time. Regards Ian |
Help with conditional formatting in Excel 2010
Preselect A through J for as many rows as you would be using.
For example select A1:J100 Set up your conditions for Column A like Use a Formula =$A1="Paid" then format and =$A1="Unpaid" then format Make sure you use the $ sign as I have shown which locks the column but allows the row to increment down to row 100 Gord On Sun, 12 Feb 2012 23:26:29 -0000, "Ian R" wrote: Thanks for replying. I have set up the 3 conditions which work fine but only in Col A. The formatting is not being applied across the row from Col A thru to J. This is where I'm stuck as I'm not sure where I'm going wrong. Do you have any suggestions on what I can check to see why it not happening in the other columns? Thanks again for your time. Regards Ian |
I have found setting conditional formatting the way I want in Excel 2003
quite easy but I€™m getting tied up in knots trying to achieve the same thing in Excel 2010. __________ memory foam mattress | adjustable mattresses | memory pillow |
Help with conditional formatting in Excel 2010
Ian R submitted this idea :
"GS" wrote in message ... So what you want to do is set up 3 conditions. The 1st condition to evaluate 'TRUE' wins! -- Garry =============== Hi Garry Thanks for replying. I have set up the 3 conditions which work fine but only in Col A. The formatting is not being applied across the row from Col A thru to J. This is where I'm stuck as I'm not sure where I'm going wrong. Do you have any suggestions on what I can check to see why it not happening in the other columns? Thanks again for your time. Regards Ian As Gord suggests, you MUST use formulas AND the ref to column A MUST be absolute. If you did not prefix A with the $ character then your other columns are referencing themselves and not column A. Clicking on any cell in B:J and opening the CF dialog should reveal what's wrong. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Help with conditional formatting in Excel 2010
"Gord Dibben" wrote in message ... Preselect A through J for as many rows as you would be using. For example select A1:J100 Set up your conditions for Column A like Use a Formula =$A1="Paid" then format and =$A1="Unpaid" then format Make sure you use the $ sign as I have shown which locks the column but allows the row to increment down to row 100 Gord ============================= Gord Thank you very much. That was just what I needed. Ive now got it working exactly how I want it. Cheers Ian |
Help with conditional formatting in Excel 2010
"GS" wrote in message ... As Gord suggests, you MUST use formulas AND the ref to column A MUST be absolute. If you did not prefix A with the $ character then your other columns are referencing themselves and not column A. Clicking on any cell in B:J and opening the CF dialog should reveal what's wrong. -- Garry ========================= Hi Garry Thanks again. Yes that's what I was missing and I can see the difference it makes now. Cheers Ian I^) |
Help with conditional formatting in Excel 2010
Good to hear.
Thanks for the feedback. You can learn more about the usage of the $ signs by looking at relative and absolute cell addresses in help. Gord On Tue, 14 Feb 2012 00:25:52 -0000, "Ian R" wrote: "Gord Dibben" wrote in message .. . Preselect A through J for as many rows as you would be using. For example select A1:J100 Set up your conditions for Column A like Use a Formula =$A1="Paid" then format and =$A1="Unpaid" then format Make sure you use the $ sign as I have shown which locks the column but allows the row to increment down to row 100 Gord ============================= Gord Thank you very much. That was just what I needed. Ive now got it working exactly how I want it. Cheers Ian |
All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com