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

  • Thread starter Thread starter NYAZCA
  • Start date Start date
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
 
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.
 
Back
Top