how do i set up a formula in conditional formatting

V

veena

Hi there, i need help in conditional formatting i need a formula that will
highlight if column A if it is over half of column B
A B
21 12
6 4
12 24

Please let me know what i should do. thanks
Veena
 
D

Dave Peterson

Select A1 through A## (as far as you want).
With A1 the activecell
Format|Conditional formatting
Cell value is
Greater than or equal to
=b1/2

And give it a nice format.

You wanted to format the stuff in column A, right?
 
D

Dave Peterson

Oops. You said it had to be over half of column B.

Select A1 through A## (as far as you want).
With A1 the activecell
Format|Conditional formatting
Cell value is
Greater than (Not greater than or equal to!)
=b1/2

And give it a nice format.

You wanted to format the stuff in column A, right?
 
V

veena

can you please show me exactly how i am suppose to write the formula its not
working for me.
 
D

Dave Peterson

=b1/2

is the formula I used.

The activecell was A1.

What did you use and what was the activecell when you tried it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top