Aug 25 2021 07:42 AM
Aug 25 2021 09:07 AM - edited Aug 25 2021 09:18 AM
Is there a function in ASAP Utilities that will enable me to return a value based upon the colour of another cell? I can't find such function.
Jun 14 2022 07:27 PM
Hi @Hans Vogelaar , is there any functions work for the color define by conditional format? I want to return header for the cell first filled with red in a row, but solution I find only work for the color defined directly, not work for conditional format... thanks in advance...
Jun 15 2022 03:02 AM
The problem is that the actual formatting applied by conditional formatting is not available in a cell formula.
Instead of referring to the color, you'll have to use the conditions behind the conditional formatting rules. For example, if a cell is colored red if its value is greater than 100, your formula would have to search for values greater than 100.
Jun 15 2022 03:05 AM