Conditional Formatting not giving the result I want

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
792
I've got all the transactions from my bank statement. Date, Transaction Details, Funds Out, Funds In, in A-D.

Now I wanted to highlight my spendings, everything that was 50-100 one color and 100+ another color. So I put on conditional formatting, first I chose everything over 50, highlighted blue, then I chose everything over 100, highlighted purple. So far so good.

Problem that's happening: When I filter purple (everything over $100) its showing me both everything over $100, and a lot of blanks (which would have entries in Funds In but empty in Funds Out). Can anyone explain this?


Here's a pic below of the Conditional Formatting rules. D826 is where my subtotal formula is.





-- removed inline image ---


EDIT - I pasted a picture which showed up when I was writing this post but not after submitting. The picture thing here is such a pain! Its asking me for a **** link. Is there no way to upload a picture straight from my computer without using a 3rd party site?


I guess I'll type up the Manage Rules:

Cell Value > 100 (purple color highlight shown here) =$C:$C, $D$826
Cell Value > 50 (blue color highlight shown here) =$C:$C, $D$826
 
Last edited:

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top