Posted to microsoft.public.excel.misc

fruitchunk fruitchunk is offline

external usenet poster

Posts: 35

Conditional Formatting by formula

I want a special format when the cell in column E is MOD,10.375 and the cell
in column F is MOD,10.006944

I know how to write it in a regular formula, but I don't know how to create
a rule description. How would enter
=IF(MOD(E1,1)0.375,IF(MOD(F1,1)0.006944,ALERT,)) in "use a formula to
determine which cells to format"

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 with formula	CClark	Excel Discussion (Misc queries)	3	February 26th 10 07:28 PM
Conditional formatting in a formula	Annie1904	Excel Discussion (Misc queries)	1	June 5th 08 03:14 PM
Conditional formatting as a formula	tbsolms	Excel Worksheet Functions	0	March 8th 07 10:49 PM
Conditional formatting formula	David Rose	Excel Worksheet Functions	3	March 20th 06 11:54 PM
conditional formatting formula	Jack Sons	Excel Discussion (Misc queries)	6	April 5th 05 09:50 AM

All times are GMT +1. The time now is 09:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us