UDF IF cell color is yellow then "Hb" else Formula

[HaroonSid]

hi,
i am using this formula to get desired result

Please Login or Register  to view this content.

I Want
if H10 = "color index = 6"
then "HB"
Else =IF(B10=$AC$9,AI10,IF(B10=$AD$9,AI10,AH10))


tried a UDF but not working

Please Login or Register  to view this content.

.


HOPE SOME ONE WILL HELP

THANK YOU

[humdingaling]

Functions can only return values, not formulas

either embed the formula into the UDF or use the UDF to do the cell color portion only

[HaroonSid]

OK
Thank you for the reply

Please Login or Register  to view this content.

i will use above formula in this form

=Filled(b10)

If I Change Color Of B10 to Yellow (Interior.ColorIndex = 6)
then
i have a question

will this UDF will update auto, i mean B10 = 1

[humdingaling]

you can just shorten it to

Please Login or Register  to view this content.

anyways no it will not be auto
changing a colour of a cell will not update UDF automatically you need to refresh it manually ie press CTRL + ALt + F9 (normal F9 shouldn't work unless you put application.volatile in) or some other method to automatically update functions can be done in VBA

like

Please Login or Register  to view this content.

[HaroonSid]

thank you very much