In the attached sample I want to populate cell D1 with the number 1 if cell A4 is yellow.



Is this possible without VBA?

thanks for looking at my problem!

Attached Files

Can this be done.xlsx (8.7 KB, 11 views)

I'm afraid there is no non VBA solution for this question. You will need a UDF

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

you can try conditional formatting,it will get what you want

it's not work , I thought you want fill cell A4 yellow ,if cell D1 is number 1