IS THIS CONDITIONAL FORMAT

J

Julian Campbell

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
 
J

JulieD

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.
 
B

Bob Phillips

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
 
R

Ragdyer

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.
 
J

Julian Campbell

Works great, Thanks everyone

Julian

Ragdyer said:
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.
Click to expand...
 
Top