Highlighting a row with conditional formatting...

[AppDeveloper]

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!

 

[Tazguy37]

Using a condition like so, in conditional formatting; Formula is: =$A1>$C1

Copy it wherever you want using the format painter. Hope that helps!

 

[PA HS Teacher]

Click on A1, Go to Conditional Fomatting, Choose Formula is,
=A1>C1 Choose your desired conditional format.

Copy A1,


Highlight All Cells you wish to follow these instructions...eg A1:C20

Edit Paste Special Formats.