Posted to microsoft.public.excel.misc

Steen

external usenet poster

Posts: 104

Conditional Formating - Different row color also when using filter

Hi

Can anyone give a hint on how to make each 2'nd line colored - also when
using filtering. I am currently using conditional format formular:
mod(row();2)=0, but when using filter it happens that nestet rows has all odd
or even numbers, resulting in the same color.

Any suggestions to solve this issue?

/Steen

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
Multiple Conditional Formating	Mandeep Dhami	Excel Discussion (Misc queries)	8	June 16th 06 06:24 PM
Conditional Formating	Dan	Excel Worksheet Functions	0	March 26th 06 11:45 PM
Conditional formating -identify blank cell	Simon Smith	Excel Worksheet Functions	3	March 9th 06 10:48 PM
VLOOKUP & Conditional Formating Help.	Excel'ed Failures	Excel Discussion (Misc queries)	6	August 16th 05 04:46 PM
conditional formating	Jed	Excel Discussion (Misc queries)	3	June 14th 05 05:11 PM

All times are GMT +1. The time now is 01:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us