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

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?

veena wrote:

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

--

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?

veena wrote:

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

--

Dave Peterson

Yes, do i use your formula would it work for this.


"Dave Peterson" wrote:

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?

veena wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote:

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?

veena wrote:

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

--

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?

veena wrote:

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

"Dave Peterson" wrote:

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?

veena wrote:

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

--

Dave Peterson


--

Dave Peterson