You are reading a single comment by @greentricky and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
greentricky
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!