D
Dave7881
Hi I need help
Im trying to set up an invoice checking spreadsheet, I nee a formula that
looks at a yes/no drop down in another cell, and then either copies a second
cell to the location or leaves it blank for example:
If A1 is selected as YES then make D1 = B1
and if A1 is selected as NO make E1 = B1
Hope this makes sense, what I'm trying to do is get the Invoice Balance to
show in a paid column in green and an unpaid column in red depending on
whether it is shown as Paid - Yes/No in the paid column.
Im trying to set up an invoice checking spreadsheet, I nee a formula that
looks at a yes/no drop down in another cell, and then either copies a second
cell to the location or leaves it blank for example:
If A1 is selected as YES then make D1 = B1
and if A1 is selected as NO make E1 = B1
Hope this makes sense, what I'm trying to do is get the Invoice Balance to
show in a paid column in green and an unpaid column in red depending on
whether it is shown as Paid - Yes/No in the paid column.