how to get if formula based on cell color

not sure it this is possible in excel if not VBA would be good too Sample book #3.xlsxSample book #3.xlsx

How about

Formula:

Please Login or Register  to view this content.

i see that works however i have sheets that will turn green with no "yes/no"
Example attachedBook sample 1.xlsx

That makes no sense to me, can you please explain exactly why a row should be yes or no?

i want it to be based on column K, O, R and U! if there is a pay date in those columns OR the total to be paid is 0 then the cell will turn green. so what i would like is column V to return "yes" if K,O,R and U are green

Do you mean that if col T is 0 it should be Yes, otherwise No?

no not exactly, if col T is 0, U will turn green (conditional formatting)

i want it so that if K,O,R,U [4 colunms] are all green then yes, otherwise no
So if one of those colunms is not green "No"

A formula cannot see colour, but maybe this is what you want

Formula:

Please Login or Register  to view this content.

can VBA detect color?

Its close but not exactly what im looking for

the easiest way to explain what im looking for is =IF(K,O,R,U=Green, "yes","No")

Yes VBA can detect colour, but if you can clearly explain EXACTLY what should happen you can use a formula.

Ok let me try to give the most details desc i can:

These are bills to be paid, that have multiple payees aka a portion for soft, master, explo and lending

Ive put the total of the bills in G, From G the portions are calculated accordingly

After the portion total col ive put pay date (L,O,R,U):

Col L,O and R have conditional formatting thats makes cell green if there is a number in the cell (DATE)
Col U has conditional formatting that makes the cell green if there is a number in the cell OR the amt in T = 0

Col V should show "yes" if L,O,R have a date and U has a date or T=0

V would show "no" If there is no date in even 1 of these cols,, unless the value of T =0 (which would make the U col green)

Isn't that what the formula I suggested does?
If not where does it fail?

when the T=0, but L,O,R has no date it still shows yes

Ok, how about

Formula:

Please Login or Register  to view this content.

this works brilliantly! thank you

Glad to help & thanks for the feedback.