I hope this one is kinda easy, but it has me stumped. So, from the "The Only Stupid Question is the One That Isn't Asked" Department . . .
If I have a specific value in, say, Cell G4 and I want to shade the range of cells from A4-G4 if that specific value appears in G4, how do I do that? I know I need to use the "Cell Value = " rule, but I can only get Excel to shade G4 only - even if I specify the range of $A$2:$G$30 (I have 30 rows where I need to do the same thing).
I'll probably hate myself when the answer is revealed, but someone please help me to hate myself. Thanks.
If I have a specific value in, say, Cell G4 and I want to shade the range of cells from A4-G4 if that specific value appears in G4, how do I do that? I know I need to use the "Cell Value = " rule, but I can only get Excel to shade G4 only - even if I specify the range of $A$2:$G$30 (I have 30 rows where I need to do the same thing).
I'll probably hate myself when the answer is revealed, but someone please help me to hate myself. Thanks.