Posted to microsoft.public.excel.misc

veena

external usenet poster

Posts: 22

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formatting using a formula	CAT	Excel Worksheet Functions	4	November 15th 08 12:09 AM
Conditional Formatting (Formula)	mpenkala	Excel Discussion (Misc queries)	6	January 31st 08 03:09 AM
need help with a formula or conditional formatting	[email protected]	Excel Worksheet Functions	8	December 4th 07 10:51 PM
Conditional formatting formula	David Rose	Excel Worksheet Functions	3	March 20th 06 11:54 PM
Conditional Formatting Formula	Cachod1	New Users to Excel	1	March 29th 05 01:57 AM

All times are GMT +1. The time now is 12:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us