Formula If then Question

[LNG2013]

Hey I need a quick formula that basically says if cell E29 is greater then or equal to cell 35 then put "Mastered" in F34, if it is less then put "Not Mastered."

Bonus points if Mastered can turn the cell to green and not mastered turns it to red!

Thanks for all your help my genius friends!

 

[Jonmo1]

Try

=IF(E29>=E35,"Mastered","Not Mastered")


Look into conditional formatting for turning the cell different colors based on different conditions.


Hope that helps.

 

[VoG]

Try

=IF(E29>E35,"Mastered","Not Mastered")

For the coloring see http://www.contextures.com/xlCondFormat01.html

 

[LNG2013]

Hey Jonmo and VoG!

Bothsolutions worked but Jonmo's did get those that are equal to as well, great job!