Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Row Color
This is my current spreadsheet:
Rows: A2 - J2 Conditional Formating 1) =$F2="Y" (format Green) 2) =$F2="N" (format Red) and this works for Row 2 What I need is to have this same format work on each row and I just cannot get it to work! Please HELP!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Row Color
A2:J2 is just one row, not many.
But you can use the format painter, the paintbrush icon on the toolbar, and copy the format of A2:J2 and paint it onto other rows. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Cindy" wrote in message ... This is my current spreadsheet: Rows: A2 - J2 Conditional Formating 1) =$F2="Y" (format Green) 2) =$F2="N" (format Red) and this works for Row 2 What I need is to have this same format work on each row and I just cannot get it to work! Please HELP!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Row Color
Rows A2:J2 comrpise only one row, row 2. So your conditional formatting is
working as it should. Do you mean columns A:J? Dave -- Brevity is the soul of wit. "Cindy" wrote: This is my current spreadsheet: Rows: A2 - J2 Conditional Formating 1) =$F2="Y" (format Green) 2) =$F2="N" (format Red) and this works for Row 2 What I need is to have this same format work on each row and I just cannot get it to work! Please HELP!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Row Color
Sorry - I meant Row 2; I highlight columns A-J for my conditional formatting
I want each row to show either red or green depending of if I type Y or N in Column F. I can get this to work on Row 2 but I cannot get it to copy until the other rows. What happens is when I use the format paint brush and then try my format - the entire worksheet turns red or green. I just want the row that has the Y or N in Column F to either turn red or green and I wanted a shortcut. I can't figure out what I'm doing wrong. Thank you so much for your help "Dave F" wrote: Rows A2:J2 comrpise only one row, row 2. So your conditional formatting is working as it should. Do you mean columns A:J? Dave -- Brevity is the soul of wit. "Cindy" wrote: This is my current spreadsheet: Rows: A2 - J2 Conditional Formating 1) =$F2="Y" (format Green) 2) =$F2="N" (format Red) and this works for Row 2 What I need is to have this same format work on each row and I just cannot get it to work! Please HELP!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Row Color
Cindy
Two methods........... 1. Select A2:J20 and enter your CF formulas, making sure you use $F2 to fix the column but not the row. 2. Select A2:J2 and enter your CF formula again with $F2 With A2:J2 selected............ Double-click on the Format Painter. Select A3:J20 to paint the format. Click once on Format Painter to end painting. Gord Dibben MS Excel MVP On Wed, 24 Jan 2007 10:18:01 -0800, Cindy wrote: Sorry - I meant Row 2; I highlight columns A-J for my conditional formatting I want each row to show either red or green depending of if I type Y or N in Column F. I can get this to work on Row 2 but I cannot get it to copy until the other rows. What happens is when I use the format paint brush and then try my format - the entire worksheet turns red or green. I just want the row that has the Y or N in Column F to either turn red or green and I wanted a shortcut. I can't figure out what I'm doing wrong. Thank you so much for your help "Dave F" wrote: Rows A2:J2 comrpise only one row, row 2. So your conditional formatting is working as it should. Do you mean columns A:J? Dave -- Brevity is the soul of wit. "Cindy" wrote: This is my current spreadsheet: Rows: A2 - J2 Conditional Formating 1) =$F2="Y" (format Green) 2) =$F2="N" (format Red) and this works for Row 2 What I need is to have this same format work on each row and I just cannot get it to work! Please HELP!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Row Color
That worked for the 1st color but it doesn't work for the 2nd color. Will it
only take the top conditional formatting or is there something else that I should do to add the 2nd format option. "Gord Dibben" wrote: Cindy Two methods........... 1. Select A2:J20 and enter your CF formulas, making sure you use $F2 to fix the column but not the row. 2. Select A2:J2 and enter your CF formula again with $F2 With A2:J2 selected............ Double-click on the Format Painter. Select A3:J20 to paint the format. Click once on Format Painter to end painting. Gord Dibben MS Excel MVP On Wed, 24 Jan 2007 10:18:01 -0800, Cindy wrote: Sorry - I meant Row 2; I highlight columns A-J for my conditional formatting I want each row to show either red or green depending of if I type Y or N in Column F. I can get this to work on Row 2 but I cannot get it to copy until the other rows. What happens is when I use the format paint brush and then try my format - the entire worksheet turns red or green. I just want the row that has the Y or N in Column F to either turn red or green and I wanted a shortcut. I can't figure out what I'm doing wrong. Thank you so much for your help "Dave F" wrote: Rows A2:J2 comrpise only one row, row 2. So your conditional formatting is working as it should. Do you mean columns A:J? Dave -- Brevity is the soul of wit. "Cindy" wrote: This is my current spreadsheet: Rows: A2 - J2 Conditional Formating 1) =$F2="Y" (format Green) 2) =$F2="N" (format Red) and this works for Row 2 What I need is to have this same format work on each row and I just cannot get it to work! Please HELP!! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Row Color
Cindy
FormatCFCondition1Formula is: =$F2="Y" Format to green pattern AddCondition2Formula is: =$F2="N" Format to red pattern Works for me. Gord On Wed, 24 Jan 2007 12:21:01 -0800, Cindy wrote: That worked for the 1st color but it doesn't work for the 2nd color. Will it only take the top conditional formatting or is there something else that I should do to add the 2nd format option. "Gord Dibben" wrote: Cindy Two methods........... 1. Select A2:J20 and enter your CF formulas, making sure you use $F2 to fix the column but not the row. 2. Select A2:J2 and enter your CF formula again with $F2 With A2:J2 selected............ Double-click on the Format Painter. Select A3:J20 to paint the format. Click once on Format Painter to end painting. Gord Dibben MS Excel MVP On Wed, 24 Jan 2007 10:18:01 -0800, Cindy wrote: Sorry - I meant Row 2; I highlight columns A-J for my conditional formatting I want each row to show either red or green depending of if I type Y or N in Column F. I can get this to work on Row 2 but I cannot get it to copy until the other rows. What happens is when I use the format paint brush and then try my format - the entire worksheet turns red or green. I just want the row that has the Y or N in Column F to either turn red or green and I wanted a shortcut. I can't figure out what I'm doing wrong. Thank you so much for your help "Dave F" wrote: Rows A2:J2 comrpise only one row, row 2. So your conditional formatting is working as it should. Do you mean columns A:J? Dave -- Brevity is the soul of wit. "Cindy" wrote: This is my current spreadsheet: Rows: A2 - J2 Conditional Formating 1) =$F2="Y" (format Green) 2) =$F2="N" (format Red) and this works for Row 2 What I need is to have this same format work on each row and I just cannot get it to work! Please HELP!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell color to red & then green when value change in 2 cel | Excel Discussion (Misc queries) | |||
in excel, how do i change the fill color? | Excel Worksheet Functions | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
background color of my cell does not change | Excel Discussion (Misc queries) | |||
Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) |