Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Coloring a Row
Hey I have set up Excel with a Drop down option through-out Column G.
If column G = 'Pass' I want that whole row to be Font.Color = Green If column G = 'Fail' I want the whole row to be Font.Color = Red How can I get this to occur automatically? I get all lost not knowing all the functions and parameters that excell uses. Please help me with this :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Coloring a Row
You can use Conditional Formatting. Select the entire row that you want to fill. Go to FormatConditional Formatting. Select the Formula is: Option and use this for formatting red. =$G3="Fail" Click on Format and select the color. Ok. Click Add For condition 2, use Formula Is =$G3="Pass" Click on Format and select the color. Ok. Click on Ok. Select the entire row again, click on the Format Painter and apply it to all the rows you need. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=499544 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Coloring a Row
1) With A1 selected, Go into <Format<Conditional Formatting
2) Choose "Formula Is" in the drop down box and enter =$G1="Pass", and choose a green format 3) Choose to add a condition (by pressing "Add"), choose "Formula Is" in the drop down box again, and enter =$G1="Fail", and choose a red format. 4) Click OK 5) Select A1 and copy the formatting across every column, and down every row you would like this formatting to occur. Does that help? -- Regards, Dave "chhanson" wrote: Hey I have set up Excel with a Drop down option through-out Column G. If column G = 'Pass' I want that whole row to be Font.Color = Green If column G = 'Fail' I want the whole row to be Font.Color = Red How can I get this to occur automatically? I get all lost not knowing all the functions and parameters that excell uses. Please help me with this :) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Coloring a Row
Hey guys none of this helped all that much :S
The entire Column of "G" needs to have this rule applied for ALL rows. The code you guys gave me is per row capable only. Is there a wild card I can use? ex =$G*="Pass" or a way to apply the rule of Column "G" coloring each row to the whole worksheet? "David Billigmeier" wrote: 1) With A1 selected, Go into <Format<Conditional Formatting 2) Choose "Formula Is" in the drop down box and enter =$G1="Pass", and choose a green format 3) Choose to add a condition (by pressing "Add"), choose "Formula Is" in the drop down box again, and enter =$G1="Fail", and choose a red format. 4) Click OK 5) Select A1 and copy the formatting across every column, and down every row you would like this formatting to occur. Does that help? -- Regards, Dave "chhanson" wrote: Hey I have set up Excel with a Drop down option through-out Column G. If column G = 'Pass' I want that whole row to be Font.Color = Green If column G = 'Fail' I want the whole row to be Font.Color = Red How can I get this to occur automatically? I get all lost not knowing all the functions and parameters that excell uses. Please help me with this :) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Coloring a Row
This should work. Using $G1 in your conditional format will allow you to drag the formula accross columns or vertically down rows keeping column G as the reference column and only changing the row number as it is copied down. Not sure without seeing an example of what you are trying to accomplish though. Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=499544 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Coloring a Row
"ALL" rows?
CTRL + a(twice in 2003) to select every row of the sheet. FormatCF and enter the 2 conditions as you were shown. Make sure you use =$G1="Pass" for condition1 and =$G1="Fail" for condition2 NOTE the $ sign to lock column G but not the row number. I think formatting the entire sheet is a bit much. Perhaps you could select cells A1:X500 or somesuch range. Gord Dibben MS Excel MVP On Tue, 10 Jan 2006 12:50:03 -0800, "chhanson" wrote: Hey guys none of this helped all that much :S The entire Column of "G" needs to have this rule applied for ALL rows. The code you guys gave me is per row capable only. Is there a wild card I can use? ex =$G*="Pass" or a way to apply the rule of Column "G" coloring each row to the whole worksheet? "David Billigmeier" wrote: 1) With A1 selected, Go into <Format<Conditional Formatting 2) Choose "Formula Is" in the drop down box and enter =$G1="Pass", and choose a green format 3) Choose to add a condition (by pressing "Add"), choose "Formula Is" in the drop down box again, and enter =$G1="Fail", and choose a red format. 4) Click OK 5) Select A1 and copy the formatting across every column, and down every row you would like this formatting to occur. Does that help? -- Regards, Dave "chhanson" wrote: Hey I have set up Excel with a Drop down option through-out Column G. If column G = 'Pass' I want that whole row to be Font.Color = Green If column G = 'Fail' I want the whole row to be Font.Color = Red How can I get this to occur automatically? I get all lost not knowing all the functions and parameters that excell uses. Please help me with this :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
Running auto correct on startup? | Excel Discussion (Misc queries) | |||
Averaging Values in Auto Filter | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |