Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Formatting
Is it possible to format a row based on a text value compared from a cell in
that row to a cell in the row above it? I review a report daily that is about 200 pages long, of which 80% of it is duplicate information. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Formatting
Let's say you have data in cells A3:K1000, and the text values that you want
to compare are in column E Start by selecting the SECOND row of data all the way to the last row. Be sure that A4 is the active cell (press Ctrl-. [that's a period] until A4 is the active cell). Now go to FromattingConditional Formatting. Choose "Formula is" and use this formula =$k4<$k3 Click on the format button and choose whatever format you want to distinguish the rows. Ok your way back to the spreadsheet. If you have to compare the data in more than one column, change the formula like so =AND($k4<$k3,$L4<$L3) "stiglo" wrote: Is it possible to format a row based on a text value compared from a cell in that row to a cell in the row above it? I review a report daily that is about 200 pages long, of which 80% of it is duplicate information. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Formatting
That is almost perfect! I should have specified how I wanted the rows
formatted...I would like to "Hide" those particular rows...Can't do that with conditional formatting...or can you? "Duke Carey" wrote: Let's say you have data in cells A3:K1000, and the text values that you want to compare are in column E Start by selecting the SECOND row of data all the way to the last row. Be sure that A4 is the active cell (press Ctrl-. [that's a period] until A4 is the active cell). Now go to FromattingConditional Formatting. Choose "Formula is" and use this formula =$k4<$k3 Click on the format button and choose whatever format you want to distinguish the rows. Ok your way back to the spreadsheet. If you have to compare the data in more than one column, change the formula like so =AND($k4<$k3,$L4<$L3) "stiglo" wrote: Is it possible to format a row based on a text value compared from a cell in that row to a cell in the row above it? I review a report daily that is about 200 pages long, of which 80% of it is duplicate information. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Formatting
No - you can't hide them in that fashion. What you can do is put the formula
=$k4<$k3 In an empty column adjacent to your data, then filter on FALSE. That will hide the multiple rows "stiglo" wrote: That is almost perfect! I should have specified how I wanted the rows formatted...I would like to "Hide" those particular rows...Can't do that with conditional formatting...or can you? "Duke Carey" wrote: Let's say you have data in cells A3:K1000, and the text values that you want to compare are in column E Start by selecting the SECOND row of data all the way to the last row. Be sure that A4 is the active cell (press Ctrl-. [that's a period] until A4 is the active cell). Now go to FromattingConditional Formatting. Choose "Formula is" and use this formula =$k4<$k3 Click on the format button and choose whatever format you want to distinguish the rows. Ok your way back to the spreadsheet. If you have to compare the data in more than one column, change the formula like so =AND($k4<$k3,$L4<$L3) "stiglo" wrote: Is it possible to format a row based on a text value compared from a cell in that row to a cell in the row above it? I review a report daily that is about 200 pages long, of which 80% of it is duplicate information. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Formatting
Thanks brother!
"Duke Carey" wrote: No - you can't hide them in that fashion. What you can do is put the formula =$k4<$k3 In an empty column adjacent to your data, then filter on FALSE. That will hide the multiple rows "stiglo" wrote: That is almost perfect! I should have specified how I wanted the rows formatted...I would like to "Hide" those particular rows...Can't do that with conditional formatting...or can you? "Duke Carey" wrote: Let's say you have data in cells A3:K1000, and the text values that you want to compare are in column E Start by selecting the SECOND row of data all the way to the last row. Be sure that A4 is the active cell (press Ctrl-. [that's a period] until A4 is the active cell). Now go to FromattingConditional Formatting. Choose "Formula is" and use this formula =$k4<$k3 Click on the format button and choose whatever format you want to distinguish the rows. Ok your way back to the spreadsheet. If you have to compare the data in more than one column, change the formula like so =AND($k4<$k3,$L4<$L3) "stiglo" wrote: Is it possible to format a row based on a text value compared from a cell in that row to a cell in the row above it? I review a report daily that is about 200 pages long, of which 80% of it is duplicate information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |