Posted to microsoft.public.excel.misc

Mike

Posts: n/a

Conditional Format Formula

Hey, can anybody help me with this possible formula?

I basically want my rows to alternate colors, but only alternate if there is
something in the row... so,

if row contains something, then mod(row(),2).

How could I do this?

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 Format	Graham Haughs	Excel Discussion (Misc queries)	4	February 5th 06 02:42 PM
Conditional format formula	ron b	Excel Discussion (Misc queries)	4	January 31st 06 05:11 PM
Changing a Formula in Conditional Formatting	Dee	Excel Worksheet Functions	1	November 2nd 05 04:30 PM
Conditional formatting...cont. from 9/25	Guenzak	Excel Discussion (Misc queries)	4	September 26th 05 10:55 PM
Conditional Format Formula Needed	PAR	Excel Worksheet Functions	11	May 20th 05 08:45 PM

All times are GMT +1. The time now is 04:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us