Dante12
New Member
- Joined
- Jan 21, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
- Mobile
- Web
Hello,
I am trying to format one cell based on three other cells meeting their own conditions. For example, A2, A4, & A6 are conditioned to turn green as long as they are lower than the numbers of their adjacent cells A3, A5, & A7. I need A1 to also turn green once these initial cells have met the requirments.
I am trying to format one cell based on three other cells meeting their own conditions. For example, A2, A4, & A6 are conditioned to turn green as long as they are lower than the numbers of their adjacent cells A3, A5, & A7. I need A1 to also turn green once these initial cells have met the requirments.