Thursday, September 6, 2018

Excel conditional formating: query cell color



I know how to use the conditional formatting.



I apply a color to some cell based on values.




I have a lot of lines, each for a different product and for each product a list of values in rows.



With the conditional formatting I can set a color depending the values.



Now the question : For each product name, I set manually a cell color and I want to use THIS product color to be used by the conditional formatting to be applied on the values (not a color fixed in the dialog box).



Thanks you


Answer



I am always surprised by the nooks and crannies of Excel, but it looks like the answer is "no". The function that should have this feature would be the CELL function, in which you can query for metadata about cells, but the "color" attribute of this function does not return the actual color of a cell, but rather is a binary attribute. More info here.


No comments:

Post a Comment

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...