You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
I think this is another answer of "that isn't easy to do".
In my experience Excel sees the conditional formatting rather than the background colour as the format so functions which use the colour don't work.
Although, if you're using conditional formatting rules to highlight the cells can't you use the same rules in formulas to get the info. I'd guess sumifs or a pivot table or similar would return it.
aggi
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!