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

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

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

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.


"NYAZCA" wrote:

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