Conditional formatting using formulas

I am havings ome difficulty getting to format a particular rows based on the values present in a particular cell in that row.

I want the background color of Row N (N=1...2..3..) to become yellow if the value in cell $F$N , F being the column , is less than 6 but greater than 3.

Like for example if $B$6 is 4.5 , then the entire row of 6 should have a background color of yellow.

Can anybody please help ?

Hi,

Select the rows and then try this formula in conditional formatting

=AND($N1>3,$N3<6)

or

=IF(AND($N1>3,$N3<6),TRUE,FALSE)



VBA Noob

Thanks VBA noob.Can you clarify what $N1 and $N3 are ? Instead of them can you give actual cell values ?

Hi Sorry,

Totally miss understood the question.

Try this using Conditional formatting

=OR($A1<6)*AND($A1>3)

VBA Noon