Format one cell in a row based on value of another cell in that ro

N

NYAZCA

I have a worksheet with Columns A through E with muliple rows.
I want to format cell En if the contents of cell Bn equals the contents of
Cell F1
 
M

Mike H

Hi,

Select column E by clicking the letter E at the top then enter the following
conditional format formula

=and(b1<>"",b1=$f$1)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Top