I'm having an Excel sheet, mentioning the status of a task, with following columns:
Task | ID | First answer date | Workaround date | Solved date | Scheduled date | Still_Open
Still_Open contains the following formula:
The result of this can by
I've applied a conditional formatting in order to clearly see the
TRUE cases, but now there are some cases where I need to replace the formula by a fix value
The conditional formatting will show both
TRUE values (the fix values and the formula results) in the same, which I don't like.
Is there a way to distinguish fix values from formulas, using conditional formatting?