Forum Discussion
Conditional Formatting based on the color of cell
I have a question on conditional formatting based on another cell's color. Say for example, cells A2 to A5 are grouped with A1 being the parent. A2 to A5 is either green or red and if any of those 4...
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.