Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting an entire row using conditional formatting.
I know how to use conditional formatting to apply a format to a certain cell if it's value is a certain range or item. Is there any way to highlight the entire rown containing that item if it matches ? For example, I have columns A, B, and C. If column C = X , I want to highlight the entire row (A, B, C) for that entry. Any way to do this ? -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=505232 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting an entire row using conditional formatting.
Hi!
Select the range of cells in question. I'll assume A1:C1 Conditional Formatting Formula is: =$C$1="x" Set your format(s) OK out Biff "SystemHack" wrote in message ... I know how to use conditional formatting to apply a format to a certain cell if it's value is a certain range or item. Is there any way to highlight the entire rown containing that item if it matches ? For example, I have columns A, B, and C. If column C = X , I want to highlight the entire row (A, B, C) for that entry. Any way to do this ? -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=505232 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting an entire row using conditional formatting.
ok .. problem with this is I have something like 500 rows .. I would have to sit and enter that for each row individually .. would take forever. Any shorter ways ? -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=505232 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting an entire row using conditional formatting.
Select the range of cells. I'll assume it's A1:C500
Formula is: =$C1="x" Biff "SystemHack" wrote in message ... ok .. problem with this is I have something like 500 rows .. I would have to sit and enter that for each row individually .. would take forever. Any shorter ways ? -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=505232 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting an entire row using conditional formatting.
Works absolutely perfect man .. thanks !! I know have already helped alot but would you mind explaining how you get that formula ? If not no biggie .. it's doing what I need thanks. -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=505232 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting an entire row using conditional formatting.
The cells to be colored are based on the selection, so you
selected all cells -- well you could have anyway. The formula is based on the active cell and determines whether the cell will be colored. If A1 is the active cell and you used =A1=1 then each cell would be evaluated against 1 If you use $A1 in stead of the active cell then each cell will be evaluated to what is in column A and the active cell could be any cell on row 1. More information on Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "SystemHack" wrote Works absolutely perfect man .. thanks !! I know have already helped alot but would you mind explaining how you get that formula ? If not no biggie .. it's doing what I need thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
Highlighting text using conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copying conditional formatting to an entire column | Excel Discussion (Misc queries) |