Highlighting rows using conditional formatting?

[Michael Saffer]

Hello everyone,

I have about 40,000 records, each on separate rows, where columns E and F
contains answers to the logical y/n question. This is an example of row 1:

681585 FRSASUN 7DAY BDRENEWCARR7DAY n
n

In the 6 columns of data, columns E and F are both "n".
Is there a way to highlight the entire row 1 with yellow whenever E1 and F1
both n?

I looked at conditional formatting and wasn't able to find the answer there.
I'm familiar with copying and pasting code into new macros, thanks to this
forum. So any solution would be great.

Thank you very much, again.
Michael Saffer

 

[Frank Kabel]

Hi
- highlight/select row 1
- goto 'format - Conditional Format)
- enter the formula
=($E1="n")*($F1="n")
- choose your format

 

[Ron de Bruin]

One way

Select row 1 till ?
And use this formula Michael

=IF(COUNTIF($F3:$G3,"n")=2,TRUE,FALSE)

 

[Frank Kabel]

hi Ron
you probably meant:
=IF(COUNTIF($F1:$G1,"n")=2,TRUE,FALSE)

if you start in row 1 )

 

[Ron de Bruin]

Thanks Frank
I copy the formula from the wrong cell