IS THIS CONDITIONAL FORMAT
 

I have a line of information showing product description and initial
quantity purchased.

On the same line I have a daily use mon / fri with an auto sum at the end of
the row showing balance remaining.

When this last cell reaches 0, I would like the whole line to highlighted in
a colour (text or background)

Again, the same as above if the end cell reaches <0

Any Ideas

Thanks

Julian

Hi Julian

yes, this can be done using conditional formatting .. it's a shame that you
didn't mention your ranges in the post. So i'm assuming that the first row
that you want to apply the conditional formatting to is row 2 and your "last
cell" is in column J.
firstly, scroll so that row 2 is the first row that you can see at the top
left of the worksheet
then select from row 2 (use the numbers) down to the last row you want to
apply the formatting to
then choose
format / conditional formatting from the menu
choose
formula is
and type
=$J2=0
click on the format button, go to the patterns tab, choose a fill colour and
click OK
now click on the ADD button
choose
formula is
type
=$J2<0
click on the format button, choose a format
click OK twice

if you want both the =0 and <0 conditions to have the same formatting in the
first condition type
=$J2<=0
and skip the second condition.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Julian Campbell" wrote in message
...
I have a line of information showing product description and initial
quantity purchased.

On the same line I have a daily use mon / fri with an auto sum at the end
of the row showing balance remaining.

When this last cell reaches 0, I would like the whole line to highlighted
in a colour (text or background)

Again, the same as above if the end cell reaches <0

Any Ideas

Thanks

Julian

It is.

Select all the cells in a row (say A2:H2, total in H2), and all rows
Menu Format Conditional formatting
Change Condition 1 to Formula Is
Add a formula = $H2=0
Click Format
Select pattern and pick a colour
OK
Click Add condition
Change Condition 1 to Formula Is
Add a formula = $H2<0
Click Format
Select pattern and pick a colour
OK
OK

--
HTH

Bob Phillips

"Julian Campbell" wrote in message
...
I have a line of information showing product description and initial
quantity purchased.

On the same line I have a daily use mon / fri with an auto sum at the end
of
the row showing balance remaining.

When this last cell reaches 0, I would like the whole line to highlighted
in
a colour (text or background)

Again, the same as above if the end cell reaches <0

Any Ideas

Thanks

Julian

Say that your Sum() formula column starts in K2 and goes down to K20.

Select A2 to K20, then:

<Format <ConditionalFormat,

Click "Formula Is", and enter this:

=$K2<=0

Now, click on the "Format" button, and choose a color for your font and/or a
pattern color for the background cell color.
Then <OK <OK, and you should be done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Julian Campbell" wrote in message
...
I have a line of information showing product description and initial
quantity purchased.

On the same line I have a daily use mon / fri with an auto sum at the end
of
the row showing balance remaining.

When this last cell reaches 0, I would like the whole line to highlighted
in
a colour (text or background)

Again, the same as above if the end cell reaches <0

Any Ideas

Thanks

Julian

Works great, Thanks everyone

Julian

"Ragdyer" wrote in message
...
Say that your Sum() formula column starts in K2 and goes down to K20.

Select A2 to K20, then:

<Format <ConditionalFormat,

Click "Formula Is", and enter this:

=$K2<=0

Now, click on the "Format" button, and choose a color for your font and/or
a
pattern color for the background cell color.
Then <OK <OK, and you should be done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Julian Campbell" wrote in message
...
I have a line of information showing product description and initial
quantity purchased.

On the same line I have a daily use mon / fri with an auto sum at the end
of
the row showing balance remaining.

When this last cell reaches 0, I would like the whole line to highlighted
in
a colour (text or background)

Again, the same as above if the end cell reaches <0

Any Ideas

Thanks

Julian