AppDeveloper
New Member
- Joined
- Feb 1, 2005
- Messages
- 1
Hello MS Excel Gurus,
Using conditional formatting, is there a way to highlight the entire row with a color when certain conditions are met? For xample, if I have 3 columns (A1, B1 & C1; A2, B2 & C2; A3, B3 & C3, and so on...) of data all containing numbers ($ amount) and I want the whole row to be highlighted in red whenever the amount in A1 is greater than C1, and/or A3 > C3, and so on, how would I do that?
Thank you very much in advance!
Using conditional formatting, is there a way to highlight the entire row with a color when certain conditions are met? For xample, if I have 3 columns (A1, B1 & C1; A2, B2 & C2; A3, B3 & C3, and so on...) of data all containing numbers ($ amount) and I want the whole row to be highlighted in red whenever the amount in A1 is greater than C1, and/or A3 > C3, and so on, how would I do that?
Thank you very much in advance!