Excel with Conditional formating

Am using Windows 10 with MS Office 2013

I have attached an excel sheet with reference values.
I made a CONDITION FORMAT to CELL 'J15' with a rule 'Format only cells that contain' and
formatted with BLUE COLOR when J15 = F15

And i did the same with J4 that if J4=F4, J4 should cell turn BLUE, but it does not seems to work.
same with J25 and F25

Change your formula in J4 to;

Formula:

Please Login or Register  to view this content.

You are checking for duplicates but they are not identical, they just look identical because of the cell formatting.

Thank you

But what about J15... It gives me the desired results

Originally Posted by kersplash

Change your formula in J4 to;

Formula:

Please Login or Register  to view this content.

You are checking for duplicates but they are not identical, they just look identical because of the cell formatting.

The same is not working with J25

Originally Posted by kjxavier

The same is not working with J25

Hi Xavier,

If you had read and understood what kersplash has written (You are checking for duplicates but they are not identical, they just look identical because of the cell formatting.), you wouldn't have raised issues again. Now to make your job simple, I would suggest you to change certain values in your file as:

Change "INPUTS!B12" to 14358.562
Change "INPUTS!B18" to 264826.4316
Change "INPUTS!B24" to 11654.1882
Change "INPUTS!B30" to 1508.0408

You will find that the issue has been resolved.