Conditional Formatting

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by Dorian74

Hi, i'm just not that creazy about the way it screws up the table i already made.

Then I would suggest you go with Claus' CF formula ( =AND(ISNUMBER(N4),N40) ) in combination with the alternating rows one you already have.

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
How can I convert conditional formatting into explicit formatting?	Patrick Harris	Excel Discussion (Misc queries)	0	April 9th 09 12:00 AM
Conditional formatting--different formatting depending on cell con	Tammy S.	Excel Discussion (Misc queries)	3	March 30th 09 08:11 PM
Protect Cell Formatting including Conditional Formatting	Mick Jennings	Excel Discussion (Misc queries)	5	November 13th 07 05:32 PM
conditional Formatting based on cell formatting	Totom	Excel Worksheet Functions	0	January 15th 07 04:35 PM
Conditional Formatting that will display conditional data	BrainFart	Excel Worksheet Functions	1	September 13th 05 05:45 PM

All times are GMT +1. The time now is 08:28 AM.

About Us