Highlighting rows using conditional formatting?

  • Thread starter Thread starter Michael Saffer
  • Start date Start date
M

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
 
Hi
- highlight/select row 1
- goto 'format - Conditional Format)
- enter the formula
=($E1="n")*($F1="n")
- choose your format
 
One way

Select row 1 till ?
And use this formula Michael

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

if you start in row 1 :-))
 
Back
Top