Conditional Formatting
 

I am trying to use a conditional formatting formula where ...
formula is ... = a1<a2 ...then format bold blue. These are the two values
in A1 and A2 they are equal but the formating is in bold/blue. If the two
numbers are equal the formatting should not be bold/blue.
COL A
R1 $54,398.06
R2 $54,398.06

Can you tell me why - or how to fix?

=round(a1-a2,2)<0

or

=round(a1,2)<round(a2,2)


"Steve Stad" wrote:

I am trying to use a conditional formatting formula where ...
formula is ... = a1<a2 ...then format bold blue. These are the two values
in A1 and A2 they are equal but the formating is in bold/blue. If the two
numbers are equal the formatting should not be bold/blue.
COL A
R1 $54,398.06
R2 $54,398.06

Can you tell me why - or how to fix?

Hi,

Try changing the conditional formatting formula to =ROUND(A1,2)<ROUND(A2,2).

Cheers,
A

"Steve Stad" wrote:

I am trying to use a conditional formatting formula where ...
formula is ... = a1<a2 ...then format bold blue. These are the two values
in A1 and A2 they are equal but the formating is in bold/blue. If the two
numbers are equal the formatting should not be bold/blue.
COL A
R1 $54,398.06
R2 $54,398.06

Can you tell me why - or how to fix?