Change conditional formatting to coloured alternate rows dependent on a change in date?

Posted to microsoft.public.excel.programming

excelent

external usenet poster

Posts: 695

Change conditional formatting to coloured alternate rows depen

And u can get difrent patterns modyfying the formula like:

=MOD(ROW();3)=0
=MOD(ROW();4)=0
=MOD(ROW();3)
=MOD(ROW();4)

and so on

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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, change row to certain color	Sylvan06	Excel Worksheet Functions	3	April 28th 09 01:42 AM
Conditional formatting - coloured text	Jennie	Excel Worksheet Functions	8	June 20th 08 03:28 PM
Conditional formatting does not change when values change. ??	Texana	Excel Worksheet Functions	4	August 20th 07 12:20 AM
How do I use Conditional Formatting to change pos No to a Neg No	Wannabegeek	Excel Discussion (Misc queries)	1	August 6th 07 04:49 AM
Can't change font on conditional formatting	faustino Dina[_2_]	Excel Programming	3	February 19th 04 03:13 PM

All times are GMT +1. The time now is 10:01 PM.

About Us