Conditional Formatting Question

[daknight]

I have a spreadsheet with a list (rows) of Goals. The columns are months. I have the cells conditionally formatted to background YELLOW if the value entered is =/> goal. (Let's say Goal is 1.)
What I want is if the goal is met two consecutive months, and the cells have changed to background YELLOW, I want the cell for the next month to turn background GREEN to show Goal has been met for three consecutive months, and adjacent cells to be GREEN as long as the Goal is met. (Do not want to have to do this manually as the list is LONG).
Is this do-able?
Thanks for your help!
DAK

 

[Brian from Maui]

I have a spreadsheet with a list (rows) of Goals. The columns are months. I have the cells conditionally formatted to background YELLOW if the value entered is =/> goal. (Let's say Goal is 1.)
What I want is if the goal is met two consecutive months, and the cells have changed to background YELLOW, I want the cell for the next month to turn background GREEN to show Goal has been met for three consecutive months, and adjacent cells to be GREEN as long as the Goal is met. (Do not want to have to do this manually as the list is LONG).
Is this do-able?
Thanks for your help!
DAK

Maybe,

=(A1>=1)*(B1>=1)*(C1>=1)