Conditional formating not working

**JukeBoxHero** · 03-26-2015, 09:01 AM

See Example below (i cant upload the one i am using unfortunatley).

a b c d e
1 10:00 11:00 12:00 13:00
2 10:00 11:00 12:00 13:00
3 10:00 11:00 12:00 13:00
4 11:00

in row 1,2,3 // Collumns B, C,D,E i have Time values formated in Time: 13:30

In A4 i have a time value also formatted in Time: 13:30

When using conditional formatting i use a formula to assist in matching:
Formula: =$A$4=B1
Format: Yellow
Applies to: =$B$4:$E$4

In theory this should highlight the cell wehre my time in A4 match a corresponding value in a cell above my applied cells. In the example it works with all scenarios where i change C1 to C2 to C3. But in my own spreadsheet for some reason it does not. When i change C1 to C2 or C3, the cell does not highlight. i first thought this may be a cell formatting issue and made sure they were all formatted as TIME: 13:30. this did not change the highlighitng issue. im struggling here

i have tried closing Excel, and tried re-formatting each cell to make sure they are all TIME: 13:30

Unfortunatley im under some time constraint and could really use some help if possible.

Thank you,

-Ryan

**Pauleyb** · 03-26-2015, 05:30 PM

I know you said you could not upload, but it seems like that is the best path to a solution. Sounds like you mimicked the formatting on a simple worksheet and it worked, so your theory is sound, but something is 'wrong' with the failing spreadsheet.

**FDibbins** · 03-26-2015, 06:50 PM

=$A$4=B1

Check that these 2 really are the same. Even a 1-second difference will make them different to excel.
try the following...
1. =exact($A$4,B1) FALSE indicates they do not match
2. Format both cells as General, and increase decimal places to about 15, see if they match

You may need to use round/roundup/rounddown to get them to match properly