ChrisUK
Well-known Member
- Joined
- Sep 3, 2002
- Messages
- 675
Hi,
I have a large sheet with a selection of cells with a validation list in each cell (Yes,No,Maybe). Depending on the cell value I have a conditional format set of Green, Yellow or Red.
So far so good
However, I have inserted a new column at the start of the sheet now where the cell value is also "Yes". How can I use a formula in each of my conditional formats is do what it is now but also to fire if the cell in the new column on the same row is "Yes" - is this possible
Thank in anticipation
Chris
I have a large sheet with a selection of cells with a validation list in each cell (Yes,No,Maybe). Depending on the cell value I have a conditional format set of Green, Yellow or Red.
So far so good
However, I have inserted a new column at the start of the sheet now where the cell value is also "Yes". How can I use a formula in each of my conditional formats is do what it is now but also to fire if the cell in the new column on the same row is "Yes" - is this possible
Thank in anticipation
Chris