If for color

[Jayadev Sarangi]

Hello,


Is there any formula for below issue...


Lets say - Cell A6 has yellow color, I want to write a formula in B6 having the logic - if cell A6 is yellow, then give me "Y"


Kindly advise

Jay

 

[Hui]

Jay


Did you try the Google Search bar at the Top Right of this page?


Have a look at my comments to this post:

http://chandoo.org/forums/topic/calculate-data-based-on-cell-color

or

http://chandoo.org/forums/topic/cell-colors

 

[NARAYANK991]

Hi Jay ,


Check out this link :


http://www.jkp-ads.com/articles/excelnames08.asp


Narayan

 

[Jayadev Sarangi]

Thanks for the help. But I wanted something different. Did it manually actually. But if you find solution, please do let me know.


Regards

Jay

 

[Hui]

Jay


Maybe if you post a sample file with some data we can see what your after ?

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[Jayadev Sarangi]

Well, I will share. Thanks. I need one more help on advanced drop down. Below is the requirement.


Cel A1, A2 and A3 contain 1,1 and 2 respectively. Cell B1, B2 and B3 contain A, B and C respectively. I want to have a drop down where I select 1 or 2 then in the next cell it will automatically show up the respective valude from column B. For example - if I select 1 from the drop down, in the next drop down it should only show A and B.


Kindly advise and thanks a lot for the help always.


Regards

Jay

 

[Hui]

Jay


This problem isn't related to the first problem and hence you should start a new post

Please refer to the 3 Green Sticky posts at the top of: http://chandoo.org/forums/

For instructions on how the site works


It is important to keep questions separate as it ensures they will be answered more rapidly and it makes searches easier


You may want to look at posts on Index/Match for your solution

 

[Jayadev Sarangi]

Thanks for the advise. will do that.