A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help in color index function



 
 
Thread Tools Display Modes
  #1  
Old September 17th, 2008, 09:08 PM posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
 
Posts: 12
Default Help in color index function

Hello,
I want to give conditional formatting for a cell, based on background
color of another cell without using VBA?
I know far sure using VBA we can do it, but without using VBA, i want
to perform this....
This example would help to u/s better....
if cell A2 has been shaded "yello color" then I want cell B2 to be
shaded "red color"...
Can you'll please help me on this???

Thanks in advance!
Srikanth
  #2  
Old September 17th, 2008, 10:03 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_]
external usenet poster
 
Posts: 963
Default Help in color index function

Not possible without VBA unless you can use the same criteria that made you
colour it yellow
in the first place

--


Regards,


Peo Sjoblom

wrote in message
...
Hello,
I want to give conditional formatting for a cell, based on background
color of another cell without using VBA?
I know far sure using VBA we can do it, but without using VBA, i want
to perform this....
This example would help to u/s better....
if cell A2 has been shaded "yello color" then I want cell B2 to be
shaded "red color"...
Can you'll please help me on this???

Thanks in advance!
Srikanth



  #3  
Old September 19th, 2008, 03:52 AM posted to microsoft.public.excel.worksheet.functions
igorek
external usenet poster
 
Posts: 23
Default Help in color index function

you must use macro or special function writen separatelly. The only way i
know of is to use asap-utilities (search web for it). It installs the
function that will allow you to do taht via formula like:
=asapinteriorcolorindex()

good luck

" wrote:

Hello,
I want to give conditional formatting for a cell, based on background
color of another cell without using VBA?
I know far sure using VBA we can do it, but without using VBA, i want
to perform this....
This example would help to u/s better....
if cell A2 has been shaded "yello color" then I want cell B2 to be
shaded "red color"...
Can you'll please help me on this???

Thanks in advance!
Srikanth

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:48 PM.


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