Conditional Formating Text equaling to Number formats

[dave_b_johnson]

Conditional Formating Text equaling to Number formats:

Example:
C20 is '436.59 (its pasted as text often is must remain as text) and D20 is 436.9535

I want D20 to have only 2 decimals and turn green if it equals C20. And turn red if it doesnt equal C20.

 

[Andrew Poulsom]

Welcome to MrExcel.

Try the Conditional Formatting formula:

=ROUND(D20,2)=(C20+0)