Conditional formatting

[Stclements1]

I want to colour the row A3:Q3 if the value in F3 is >0. I have managed to shade F3 when it is >0 but have not been able to create a formula in conditional formatting that allows me to do the whole row based on the value in F3

 

[etaf]

for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

$A$3:$Q$3


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=$F3 > 0


FormatÖ [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[Stclements1]

That's perfect and so simple. I believe Occams Razor is what I should have followed.

 

[etaf]

you are welcome