conditional formatting color row

[ammartino44]

Hello. How can I conditional format a row to be a certain color if values in a specific column are positive?

[GC Excel]

Hi,

Here's how to do it :

• Select the rows you want, example 1:100
• Add Conditional Formatting, Using a formula
• Type the formula, example =$K1>0 (if you want to compare with column K)
• Click Format, Fill, select a color
• Click OK

The trick is this part : =$K1>0
Make sure there is no $ in front of the row number.
Also if you select rows 5:100, the formula will be =$K5>0