Posted to microsoft.public.excel.misc

57Caddy

external usenet poster

Posts: 18

Conditional Formatting a Formula Field

Rather than creating a bunch of new fields, is it possible to conditional
format a field that has a formula in it? I've attached what I have below for
cell D5. We want anything 3 or greater to have the whole cell green and
anything below 3 to be red.

Thank you

=IF(C5=17.5%,"5",IF(C5=16.25%,"4",IF(C5=14.25%, "3",IF(C5=13%,"2",IF(C5=0,"1","N/A")))))

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
Using string in Conditional field formula	Roger	Excel Discussion (Misc queries)	4	March 23rd 07 04:08 AM
Conditional Formatting formula	tankerman	Excel Discussion (Misc queries)	2	December 22nd 06 05:34 PM
Conditional Formatting of Pivot Table Field	jdanderson02	Excel Discussion (Misc queries)	2	February 9th 06 08:41 PM
Conditional Formatting Formula	jgp_2	Excel Worksheet Functions	1	February 3rd 06 06:37 PM
Conditional formatting on named text field	Sharon P	Excel Discussion (Misc queries)	1	June 21st 05 10:30 PM

All times are GMT +1. The time now is 02:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us