Excel 2002: How to condition format rows with empty cells ?

[Mr. Low]

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

 

[T. Valko]

Try using the Subtotals feature.

Select your data
Goto the menu Data>Subtotals

At each change in CODE
Use function SUM
Add subtotal to AMOUNT
OK

 

[FSt1]

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....
format>conditional formatting. you can set the format base on the results of
a formula.
sorry.
regards
FSt1

 

[T. Valko]

It seems that I've misunderstood your post.

You want conditional formatting!

What do you want the formatting based on?

 

[Mr. Low]

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

 

[Mr. Low]

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

 

[T. Valko]

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 Format>Conditional 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

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