Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 266
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a range of data a1:d4 (4 rows x 4 columns range). I also have a range of data in column e1:e4. If I populate E1 with the value 2, I want the second cell in the range a1:d1 to be formatted with a green fill (B1).
If I populate E4 with the number 3, I want the third cell over in the row to be formatted with a green fill (C3).
If there are no values in the e1:e4 range, then there is no conditional formatting required.
Any help appreciated.
I have a range of data a1:d4 (4 rows x 4 columns range). I also have a range of data in column e1:e4. If I populate E1 with the value 2, I want the second cell in the range a1:d1 to be formatted with a green fill (B1).
If I populate E4 with the number 3, I want the third cell over in the row to be formatted with a green fill (C3).
If there are no values in the e1:e4 range, then there is no conditional formatting required.
Any help appreciated.