You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
My first question here is can you use a helper column?
So the column does :
If this then value else value etc etcThe you have a value you can do something with (like count if cell value is 12246 And then you can apply a format if cell is etc)
Chalfie-
I would do a if <today formula to help me get there but there are 3 entities submitting bits by a due date, if overdue the due date is red, if received from all the due date is grey so i need to count the days when it is red if that makes sense? May be worth having a look at coming in from the other side tbf
.Rodders
Hi all - trying formulate based on colour of cells (which themselves are conditionally formatted), any ideas? i.e list of tasks, when they are overdue formatted red and I want to be able to then pull the number of days overdue to charge client.
I've run =GET.CELL(38, cell) which returns numbers for a couple of colours, but seems to get confused with the conditional formatting. Had a bit of a dig online but cant seem to find anything that helpful.
Any help greatly appreciated!