Could you please advise which technical options are to have a formula in Excel based on cell color?
In the attached file:FormulaBasedOnCellColor.xlsx
there is a simple example (showing also on the print screen below) that A2 has yellow color, while A3 red one:
Could you please advise how to reach that cell B2 would calculate text "Ok" and B3 text "Nok" by a formula, which would be based on the yellow and red color of the cells in column A.
Being aware that there are VBA solutions for such scenario, however actually would like to avoid using macros
Thanks in advance,