View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] hn.srikanth@gmail.com is offline
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