Conditional Formating not working with value returned with IF statement

[MrTalo]

I have a formula that returns a number 1,3,4 with the following
=IF(E3=D3,"",(IF(E3="R","3",IF(F3="R","4","1"))))

I want to highlight values of 3 and 4 but I cant seem to get the conditional formatting to work. I have played with the format of the cells making them numbers, texts, general, etc but I think it has something to do with the value that is being returned not being recognized as a number.

Any suggestions?

 

[dreid1011]

Welcome to the board.

As is, the formula is returning the text values of 1, 3 and 4. To return them as numbers, you must remove the quotes from around them.

 

[MrTalo]

That would do it,

Thank you

 

[dreid1011]

You're welcome.