Dec 26 2021 07:29 AM
I need to get an "OK" if the background color in a cell is green or a "NO" if not.
Something like:
IF('Background Color in cell V3=green'; "OK"; "NO")
How do I do that correctly in Excel.
Dec 26 2021 10:56 AM
That's with VBA, formulae don't work with cell properties like color.
Dec 26 2021 11:53 AM
Thank you very much. Then I will not struggle with formulae in Excel further. :) I'll check out VBA and learn.
Merry Christmas and Happy New Year
Dec 26 2021 04:34 PM
Dec 27 2021 04:35 AM
Dec 27 2021 06:02 AM
Excluding VBA for the moment the minimum typing can be achieved with 0 (unpaid) or 1 (paid). The values can be presented as text by number formatting and the cell colour changed using conditional formatting If preferred, status can be selected from a dropdown.
Using VBA, event handlers could toggle the settings of selected cells.
Dec 28 2021 03:02 AM