Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Excel 2007) Format Row Color Based on X
I have a row with data spanning 6 columns. Each Col is formatted differently
(some as date, text, or numbers.) How do I change the entire row to a color if the entry in Col A (formatted as text) is equal to X? (If I try to copy Col As format across the row, it changes the formatting in the other Cols all to text.) Thx, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Excel 2007) Format Row Color Based on X
Select your range of cells, Format/ CF/ Formula Is:
=$A1="X" Note the absolute reference for the column. -- David Biddulph "Alice M." wrote in message ... I have a row with data spanning 6 columns. Each Col is formatted differently (some as date, text, or numbers.) How do I change the entire row to a color if the entry in Col A (formatted as text) is equal to X? (If I try to copy Col A's format across the row, it changes the formatting in the other Cols all to text.) Thx, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Excel 2007) Format Row Color Based on
Thx, but doesn't work or I'm still doing something wrong . Need my row all
one color, only IF Col A="X" "David Biddulph" wrote: Select your range of cells, Format/ CF/ Formula Is: =$A1="X" Note the absolute reference for the column. -- David Biddulph "Alice M." wrote in message ... I have a row with data spanning 6 columns. Each Col is formatted differently (some as date, text, or numbers.) How do I change the entire row to a color if the entry in Col A (formatted as text) is equal to X? (If I try to copy Col A's format across the row, it changes the formatting in the other Cols all to text.) Thx, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Excel 2007) Format Row Color Based on
David had provided the solution to you...
Are you selecting the whole range? Try once more Select A1:F100 Choose CF Choose Formula is Type =$A1="X" Choose Formatting This will color the row, upto Col F, if that row has X in Col A "Alice M." wrote: Thx, but doesn't work or I'm still doing something wrong . Need my row all one color, only IF Col A="X" "David Biddulph" wrote: Select your range of cells, Format/ CF/ Formula Is: =$A1="X" Note the absolute reference for the column. -- David Biddulph "Alice M." wrote in message ... I have a row with data spanning 6 columns. Each Col is formatted differently (some as date, text, or numbers.) How do I change the entire row to a color if the entry in Col A (formatted as text) is equal to X? (If I try to copy Col A's format across the row, it changes the formatting in the other Cols all to text.) Thx, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Excel 2007) Format Row Color Based on
Yes, thx. My screens in Exl 2007 are a little bit diff than his solution for
Exl 2003, but now have it working. Great job, and my sincerest thanks. "Sheeloo" wrote: David had provided the solution to you... Are you selecting the whole range? Try once more Select A1:F100 Choose CF Choose Formula is Type =$A1="X" Choose Formatting This will color the row, upto Col F, if that row has X in Col A "Alice M." wrote: Thx, but doesn't work or I'm still doing something wrong . Need my row all one color, only IF Col A="X" "David Biddulph" wrote: Select your range of cells, Format/ CF/ Formula Is: =$A1="X" Note the absolute reference for the column. -- David Biddulph "Alice M." wrote in message ... I have a row with data spanning 6 columns. Each Col is formatted differently (some as date, text, or numbers.) How do I change the entire row to a color if the entry in Col A (formatted as text) is equal to X? (If I try to copy Col A's format across the row, it changes the formatting in the other Cols all to text.) Thx, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Font Color Based on Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting based on the sum of two cells (Excel 2007) | Excel Discussion (Misc queries) | |||
Conditional format a cell based on color of another | Excel Discussion (Misc queries) | |||
Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
Excel 2007, Conditional Formatting, Format Painter | Excel Discussion (Misc queries) |