elgringo56
Well-known Member
- Joined
- Apr 15, 2002
- Messages
- 869
Row 19, columns A,B &C contain data.
Row 19, colum E contains a formula that test the condition of the data in A19,B19 & C19 and returns the word "Error" to cell E19 if all conditions are not met. In G19, I would like an IF statement that would allow me to turn A19,B19 & C19 the color Red if E19 equals the word "Error". Any ideas of what that formula would be?
Row 19, colum E contains a formula that test the condition of the data in A19,B19 & C19 and returns the word "Error" to cell E19 if all conditions are not met. In G19, I would like an IF statement that would allow me to turn A19,B19 & C19 the color Red if E19 equals the word "Error". Any ideas of what that formula would be?