Hi I'm trying to do a conditional format where as if two values from two
different cells equal a number a letter is displayed as apposed to a colour?

Thanks in advance

Hi,

I'm not sure I fully understand but you can try this

=IF(A1+B1=3,99999,"")
--
Mike

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


"Harminder" wrote:

Hi I'm trying to do a conditional format where as if two values from two
different cells equal a number a letter is displayed as apposed to a colour?

Thanks in advance

OR , do you mean
If values of A1 and B1 are 5 then a letter is displayed.

=IF(AND(A1=5,B1=5),"Letter to be displayed","")

--
Jacob (MVP - Excel)


"Harminder" wrote:

Hi I'm trying to do a conditional format where as if two values from two
different cells equal a number a letter is displayed as apposed to a colour?

Thanks in advance