LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 695
Default Conditional formating problem

Hi all

got a non static list like this 1

List wanted color
xxxBxxx1 light grey
xxxBxxx2 light grey
xxxBxxx3 light grey
xxxDxxx5 dark grey
xxxFxxx9 light grey
xxxFxxx1 light grey
xxxFxxx3 light grey
xxxFxxx7 light grey
xxxJxxx3 dark grey
xxxJxxx1 dark grey
xxxPxxx2 light grey

now i wana use conditional format (not vba) to
color betwin 2 difrent background-colors every time list change
letter in 4 position
The list can be longer and/or shorter and change too
Is that possible ?

Xecel 2003 - Vista
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 formating problem. Please help. Ayo Excel Discussion (Misc queries) 7 April 24th 09 02:50 AM
Conditional Formating Problem albertmb Excel Discussion (Misc queries) 2 January 17th 09 07:32 PM
Conditional Formating Problem MESTRELLA29 Excel Discussion (Misc queries) 6 October 13th 06 11:31 PM
formating problem, PLEASE help. guy12345 Excel Discussion (Misc queries) 5 August 31st 06 05:50 PM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"