Forum Discussion
Conditional Formatting based on the color of cell
HansVogelaarahh I see what you're saying. The color in A1 would still be based off of the text in A2:A5. Lets assume that not all of the cells in A2:A5 has text. Let's say A2:A4 has "Yes" and they are colored green. A5 has no text and is colored red. Because at least one of the cells in A2:A5 is red that means A1 will be red however there is no text in A5. Let's assume A5 was manually colored red, in this instance is there a way to conditionally format A1 to pick up on A5 as red (with no text) and A1 will automatically be colored red? I have not been able to find a solution without VBA. Any thoughts?
Thank you in advance. I def appreciate your feedback.
The method that I described should work.
If it doesn't for you, could you attach a sample workbook without sensitive/proprietary data?
HansVogelaarI played around with what you had suggested and it worked perfectly. Appreciate it!
I had also tried looking up a solution for say if columns A2:A5 did not have text. Let's say columns A2:A5 are colored either red or green (manually maybe) without any text. In that scenario, is there a way to conditional format A1 without the colors in A2:A5 being driven by the text in each cell?
If the cells A2:A5 have been colored manually, you'd need VBA to color A1.