Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a formula in conditional formatting
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a formula in conditional formatting
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a formula in conditional formatting
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a formula in conditional formatting
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a formula in conditional formatting
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a formula in conditional formatting
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting using a formula | Excel Worksheet Functions | |||
Conditional Formatting (Formula) | Excel Discussion (Misc queries) | |||
need help with a formula or conditional formatting | Excel Worksheet Functions | |||
Conditional formatting formula | Excel Worksheet Functions | |||
Conditional Formatting Formula | New Users to Excel |