NewOrderFac33
Well-known Member
- Joined
- Sep 26, 2011
- Messages
- 1,283
- Office Version
- 2016
- 2010
- Platform
- Windows
Good morning,
I have a project plan in Excel where cells in the plot area contain a formula returning a value of 1,2,or 3, with 3 conditional formatting rules resulting in the cell being colored differently e.g.
Cell Value = 1 - Cell Fill = Red
Cell Value = 2 - Cell Fill = Blue
Cell Value = 3 - Cell Fill = Green
I now need to extend these three rules to include the value in another column, so it would be something like:
Cell Value = 1 AND the value of (Cell.Row, Column B) = "Sprint1" - Cell Fill = Red
Cell Value = 1 AND the value of (Cell.Row, Column B) = "Sprint1" - Cell Fill = Blue
Cell Value = 1 AND the value of (Cell.Row, Column B) = "Sprint1" - Cell Fill = Green
Is this possible - I'm using 2010, by the way?
Thanks in advance
Pete
I have a project plan in Excel where cells in the plot area contain a formula returning a value of 1,2,or 3, with 3 conditional formatting rules resulting in the cell being colored differently e.g.
Cell Value = 1 - Cell Fill = Red
Cell Value = 2 - Cell Fill = Blue
Cell Value = 3 - Cell Fill = Green
I now need to extend these three rules to include the value in another column, so it would be something like:
Cell Value = 1 AND the value of (Cell.Row, Column B) = "Sprint1" - Cell Fill = Red
Cell Value = 1 AND the value of (Cell.Row, Column B) = "Sprint1" - Cell Fill = Blue
Cell Value = 1 AND the value of (Cell.Row, Column B) = "Sprint1" - Cell Fill = Green
Is this possible - I'm using 2010, by the way?
Thanks in advance
Pete