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

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

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

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

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

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

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