I want to know how to format entire rows with colour scales based off the value of one cell.
I have a project tracking file set up like this
tumblr_inline_pc9ktqLs2u1qjkfe6_1280.png
Which currently uses conditional formatting like this to apply a gradient colour scale to the dates depending on how near they are.
tumblr_inline_pc9kumH0A31qjkfe6_1280.png
What I'd like to be able to do is have that colouring apply to the whole project row - however so far all of the guides i've found only tell me how to set up static colouring for a row, such as formatting each cell to show a set format based on the cell the formatting is conditional on, when really I need the gradients because the real project list is much bigger and more long term and needs finer distinctions than the red for 1 week away, yellow for two-four, green for more than four type manual colour scaling.
Any suggestions? Hopefully I've explained clearly enough what I'm trying to do, but I'm happy to answer any questions that might help me get a solution!
Bookmarks