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