Home |
Search |
Today's Posts |
#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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |