Help in color index function

[hn.srikanth]

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

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[igorek]

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