Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Interior.ColorIndex of a field based on filled colors in other fieldsin the same row

Hello,

I like to have a loop for colorsetting in column A, row 2 till last, based on the filled colors in the same row in column B till Z.

If one of the indexcolors in the same row in column B till Z is red then the color in column A should be marked red.
Else
If one of the indexcolors in the same row in column B till Z is bleu then the color in column A should be marked blue.

Hopely somebody :)

regards, Johan

Reply
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
Q: UDF with Interior.colorindex Help needed MAXX Excel Programming 6 June 20th 11 05:57 PM
more on interior.colorindex issue bst Excel Programming 4 July 2nd 08 05:43 PM
interior.colorindex does not work? bst Excel Programming 11 June 28th 08 02:05 PM
Use of Interior.ColorIndex liquidhot Excel Programming 4 June 27th 05 07:22 PM
Testing for Interior.ColorIndex JeffBo Excel Programming 7 May 17th 04 09:41 PM


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

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

About Us

"It's about Microsoft Excel"