Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |