no attachments in your mail/posting just for info Color Index can be detected by *(1) making and UDF (user Definded Function)*
Public Function ColorIndex(Rng as range) as long
ColorIndex = Rng.Interior.ColorIndex
End Function
in worksheet you just use this NEW FUNCTION
=ColorIndex(B5)
another way
*(2) By Define Name using Macro Excel-4 function*
Please check in the attached workbook, hope it helps
On Sat, Mar 26, 2011 at 10:39 PM, Rajesh K R <rajeshkainikk...@gmail.com>wrote:
> attachment is added now
>
> On 3/26/11, vijayajith VA <vijayajith...@gmail.com> wrote:
> > Hai
> > attachment is missing
> > thanks
> >
> > On Sat, Mar 26, 2011 at 7:43 PM, Rajesh K R
> > <rajeshkainikk...@gmail.com>wrote:
> >
> >> Hi Experts
> >> How to understand the room status, by color code.pls check the
> >> attachment.
> >> Regards
> >> Rajesh Kainikkara
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
ctv_ColorIndex detector.xls
Description: MS-Excel spreadsheet
