Forum Discussion
Conditional Formatting Rule
For what it's worth, I'd already spent several minutes working on an answer to your earlier post of this situation, but when I went to post my reply, you'd removed the original. In the future, might I recommend that you use the "edit" function to fine-tune your request.
That said, since you have been working with Conditional Formatting--which is what you need--I will say that Conditional Formatting, useful as it certainly is, is also quite quirky and tricky to get to work as desired. It's often a case of patient trial-and-error.
Having said that, you could help us help you by posting a copy of the actual workbook (an image is of very limited value). Put it on OneDrive or GoogleDrive with a link pasted here that grants access.
And I need to ask if all those other colors--it's a very "busy" worksheet--are the result of conditional formatting themselves? And can you tell us a bit more of the context here: what's the business application? What's the overall objective or desired result?
Whenever I see a sheet like this, which looks as if you're combining the Input end of things with the Output --this may be an incorrect assumption on my part--I wonder if you wouldn't be better served by putting the raw data (Input) on one sheet by itself, with minimal or no formatting, and then create an Output sheet that draws on the raw data (and maybe a table or two), adding colors and other formatting features to that output, where the beautification makes more sense (although still delay that until you're nearing the end of the design process).