Highlighting?

[Chadbg]

Can I write a formula that will highlight line 8 if the value of box C8 is greater then 1.

[NBVC]

Select Row 8 and go to Format|Conditional Formatting, select Formula Is from 1st drop down and then enter formula:

=$C8>1

click Format and choose from Pattern tab

Click Ok

Click Ok to finish.

[Chadbg]

Did not work nothing highlighted. This works well in just a cell but does not seem to work for a row.

Select Row 8 and go to Format|Conditional Formatting, select Formula Is from 1st drop down and then enter formula:

=$C8>1

click Format and choose from Pattern tab

Click Ok

Click Ok to finish.

[NBVC]

Did you select the whole row 8 first? Then apply the formatting as described?

[pleiadeez7]

If you want to highlight entire rows if any cell in column C is greater than 1, try this:

Highlight the whole worksheet
Go to Conditional Formatting
Select "New Rule"
Select "Use a formula to determine which cells to format"
Enter this formula: =indirect("C"&row())>1
Click on the "Format" button and choose your fill color
Click OK