| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to condition format rows with empty cells ?
Dear Sir,
I have the following workshhet: A B C 1 CODE DATE AMOUNT 2 L14 08/07/04 520 3 L14 02/07/04 330 4 L14 06/09/04 260 5 1110 <- formula 6 S16 14/07/04 210 7 S16 21/04/04 110 8 320 <- formula 9 M47 02/10/04 240 10 M47 02/10/04 360 11 600 <- formula 12 2030 <- formula A5 and B5 are emty cells while D5 is a formula cell. If I wish to format row 5,8,11 and 12 using the formula, May I know how the formula would be ? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to condition format rows with empty cells ?
Try using the Subtotals feature.
Select your data Goto the menu DataSubtotals At each change in CODE Use function SUM Add subtotal to AMOUNT OK -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Dear Sir, I have the following workshhet: A B C 1 CODE DATE AMOUNT 2 L14 08/07/04 520 3 L14 02/07/04 330 4 L14 06/09/04 260 5 1110 <- formula 6 S16 14/07/04 210 7 S16 21/04/04 110 8 320 <- formula 9 M47 02/10/04 240 10 M47 02/10/04 360 11 600 <- formula 12 2030 <- formula A5 and B5 are emty cells while D5 is a formula cell. If I wish to format row 5,8,11 and 12 using the formula, May I know how the formula would be ? Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to condition format rows with empty cells ?
hi,
formula return values, they cannot perform actions such as copy, paste, format cells or rows ect. sorry but a formula will not do what you wish. You didn't provide information at to how the rows would be formated nor what the formula was or what the results would be, so i would be hesitant to suggest anthing except to look at conditions formatting. on the menu bar.... formatconditional formatting. you can set the format base on the results of a formula. sorry. regards FSt1 "Mr. Low" wrote: Dear Sir, I have the following workshhet: A B C 1 CODE DATE AMOUNT 2 L14 08/07/04 520 3 L14 02/07/04 330 4 L14 06/09/04 260 5 1110 <- formula 6 S16 14/07/04 210 7 S16 21/04/04 110 8 320 <- formula 9 M47 02/10/04 240 10 M47 02/10/04 360 11 600 <- formula 12 2030 <- formula A5 and B5 are emty cells while D5 is a formula cell. If I wish to format row 5,8,11 and 12 using the formula, May I know how the formula would be ? Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to condition format rows with empty cells ?
It seems that I've misunderstood your post.
You want conditional formatting! What do you want the formatting based on? -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try using the Subtotals feature. Select your data Goto the menu DataSubtotals At each change in CODE Use function SUM Add subtotal to AMOUNT OK -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Dear Sir, I have the following workshhet: A B C 1 CODE DATE AMOUNT 2 L14 08/07/04 520 3 L14 02/07/04 330 4 L14 06/09/04 260 5 1110 <- formula 6 S16 14/07/04 210 7 S16 21/04/04 110 8 320 <- formula 9 M47 02/10/04 240 10 M47 02/10/04 360 11 600 <- formula 12 2030 <- formula A5 and B5 are emty cells while D5 is a formula cell. If I wish to format row 5,8,11 and 12 using the formula, May I know how the formula would be ? Thanks Low -- A36B58K641 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to condition format rows with empty cells ?
Dear Sir,
If I wish to color shade row 5,8,11 and 12 by going to Format Conditional Formating Formula. I need to know the formula to select the rows (A5:C5) with the content: blank, blank, number (calculated usung =sum formula) Thanks Low -- A36B58K641 "FSt1" wrote: hi, formula return values, they cannot perform actions such as copy, paste, format cells or rows ect. sorry but a formula will not do what you wish. You didn't provide information at to how the rows would be formated nor what the formula was or what the results would be, so i would be hesitant to suggest anthing except to look at conditions formatting. on the menu bar.... formatconditional formatting. you can set the format base on the results of a formula. sorry. regards FSt1 "Mr. Low" wrote: Dear Sir, I have the following workshhet: A B C 1 CODE DATE AMOUNT 2 L14 08/07/04 520 3 L14 02/07/04 330 4 L14 06/09/04 260 5 1110 <- formula 6 S16 14/07/04 210 7 S16 21/04/04 110 8 320 <- formula 9 M47 02/10/04 240 10 M47 02/10/04 360 11 600 <- formula 12 2030 <- formula A5 and B5 are emty cells while D5 is a formula cell. If I wish to format row 5,8,11 and 12 using the formula, May I know how the formula would be ? Thanks Low -- A36B58K641 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to condition format rows with empty cells ?
Dear Sir,
If I wish to do color shading and set the font color as red in row 5,8,11 and 12 by going to Format Conditional Formating Formula. I need to know the formula to select the rows (A5:C5) with the content: blank, blank, number (calculated usung =sum formula) Thanks Low -- -- A36B58K641 "T. Valko" wrote: It seems that I've misunderstood your post. You want conditional formatting! What do you want the formatting based on? -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try using the Subtotals feature. Select your data Goto the menu DataSubtotals At each change in CODE Use function SUM Add subtotal to AMOUNT OK -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Dear Sir, I have the following workshhet: A B C 1 CODE DATE AMOUNT 2 L14 08/07/04 520 3 L14 02/07/04 330 4 L14 06/09/04 260 5 1110 <- formula 6 S16 14/07/04 210 7 S16 21/04/04 110 8 320 <- formula 9 M47 02/10/04 240 10 M47 02/10/04 360 11 600 <- formula 12 2030 <- formula A5 and B5 are emty cells while D5 is a formula cell. If I wish to format row 5,8,11 and 12 using the formula, May I know how the formula would be ? Thanks Low -- A36B58K641 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to condition format rows with empty cells ?
A5 and B5 are emty cells while D5 is a formula cell.
I need to know the formula to select the rows (A5:C5) with the content: blank, blank, number Which cell contains the formula, C5 or D5? Lets assume it's C5. Select the range C2:C12 Goto the menu FormatConditional Formatting Formula Is: =AND(COUNTA(A2:B2)=0,ISNUMBER(C2)) Click the format button Click the Font tab Set the font color to RED OK out -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Dear Sir, If I wish to do color shading and set the font color as red in row 5,8,11 and 12 by going to Format Conditional Formating Formula. I need to know the formula to select the rows (A5:C5) with the content: blank, blank, number (calculated usung =sum formula) Thanks Low -- -- A36B58K641 "T. Valko" wrote: It seems that I've misunderstood your post. You want conditional formatting! What do you want the formatting based on? -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try using the Subtotals feature. Select your data Goto the menu DataSubtotals At each change in CODE Use function SUM Add subtotal to AMOUNT OK -- Biff Microsoft Excel MVP "Mr. Low" wrote in message ... Dear Sir, I have the following workshhet: A B C 1 CODE DATE AMOUNT 2 L14 08/07/04 520 3 L14 02/07/04 330 4 L14 06/09/04 260 5 1110 <- formula 6 S16 14/07/04 210 7 S16 21/04/04 110 8 320 <- formula 9 M47 02/10/04 240 10 M47 02/10/04 360 11 600 <- formula 12 2030 <- formula A5 and B5 are emty cells while D5 is a formula cell. If I wish to format row 5,8,11 and 12 using the formula, May I know how the formula would be ? Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to conditional format a row of cells ? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to eliminate empty spaces ? | Excel Discussion (Misc queries) | |||
| How to eliminate empty rows in Excel 2002 worksheet ? | Excel Discussion (Misc queries) | |||
| format group of rows based on condition | Excel Discussion (Misc queries) | |||
| Format to hide empty rows | Excel Discussion (Misc queries) | |||
Linear Mode
