PC Review


Reply
Thread Tools Rate Thread

Conditional formats

 
 
Sandy
Guest
Posts: n/a
 
      10th Mar 2008
I have a situation where given certain criteria conditional formats are set.
One in particular sets the background colour of cells to Light Yellow
(Interior.ColorIndex = 36). What I would like to do is the following :-

Function YellowBack(MyRange As Range)

Dim MyCell As Range
YellowBack = False

For Each MyCell In MyRange
If MyCell ***(has conditional format with Light Yellow
background)*** Then
YellowBack = True
Exit Function
End If
Next MyCell

End Function

I have tried the "If" line :-
"If MyCell.Interior.ColorIndex = 36 Then"
but the conditionally formatted colour is not being identified - I presume
it is identifying the un- conditionally formatted background colour - if
you see what I mean.

Any help gratefully received.
Sandy


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formats, how to scroll and view all formats? Bill E Microsoft Excel Worksheet Functions 0 12th May 2010 07:58 PM
> 6 CONDITIONAL FORMATS Songoku Microsoft Excel Misc 7 4th Jul 2008 12:47 AM
Conditional formats- paste special formats? =?Utf-8?B?amNhcm5leQ==?= Microsoft Excel Misc 1 1st Nov 2007 06:37 PM
paste conditional formats as formats =?Utf-8?B?bGVv?= Microsoft Excel Misc 2 5th Jul 2007 10:06 AM
More Than 3 Conditional Formats SamuelT Microsoft Excel Misc 1 21st Jun 2006 02:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:32 AM.