Posted to microsoft.public.excel.worksheet.functions

Carol

external usenet poster

Posts: 115

how do I do conditional formatting for absolute values?

I am trying to set up conditional formatting so that an absolute value
greater than 3 will change the cell background color to red. I have tried:
=(abs(f5))3 with f5 being the cell location.

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 based on top values	Cecilia	Excel Worksheet Functions	4	January 5th 08 05:06 PM
Conditional Formatting with absolute references	atljar	Excel Worksheet Functions	3	November 13th 07 01:32 AM
Export Conditional Formatting Values	dcohen	Excel Worksheet Functions	0	October 19th 06 01:50 PM
Conditional Formatting for multiple values	Daniinboston	Excel Discussion (Misc queries)	1	August 3rd 06 05:36 PM
Values w/conditional formatting	Fred Timmons	Excel Worksheet Functions	7	January 4th 05 03:31 AM

All times are GMT +1. The time now is 06:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us