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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|