Forum Discussion
Conditional Formatting
How can I use the data selected with `applies to` in the `control formatting rules manager` section in place of the filter data in the `edit formatting rule` section, or is it even possible to use it...
Let me first say that Conditional Formatting is one of Excel's features where I often find myself doing trial and error through several iterations to get the result I'm looking for. (I just went through it about 45 minutes ago on a spreadsheet of my own.)
Conditional Formatting is, I think it's safe to say, one of the less intuitive of Excel's features.
That said, I find it hard to even understand what result you're looking for. Your description itself is confusing. It would help a LOT to be able to see the spreadsheet itself, but also to have a clearer description of the desired result. Are you able to attach that file or include a link to it. If the actual contains confidential info, then create a mockup that can be shared.