Hello Everyone!
Happy after summer solstice day!!
I have a number of items in a shopping list table with a total for each shop at the bottom of the shop in a column to the right. In the next column to the right is the actual receipt amount.
I have succesfully set the two columns to be yellow for where the calculated shopping amount is not equal to the receipt amount.
Now we get to the tricky bit. I'd like to count those yellow coloured pairs to count the errors of course!!
I'm trying to count cells where the interior.color = yellow and it doesn't seem to work!
Any help appreciated.
TIA
Lisa
PS. I would suggest, now that the electricity prices have gotten so high, that everyone does some checking of their supermarket receipts. I have already found 4 "errors" in 3 weeks. That they were mostly human errors is irrelevant really. Look after the pennies!!
Lisa
Colour me confused
-
- PlutoniumLounger
- Posts: 15498
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Re: Colour me confused
Why not count the number of instances where the calculated shopping amount is not equal to the receipt amount/
That is, after all, the original condition, and is strictly numeric.
I burned four KwH of electricity yesterday; that came to $0.50.Look after the pennies!!
I am at my wit's end with how to reduce my electricity bill further.
Cheers, Chris
An expensive day out: Wallet and Grimace
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Colour me confused
What Chris said. It's not easy to work with colours applied by conditional formatting, so work with the conditions instead.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 964
- Joined: 08 Nov 2012, 17:54
Re: Colour me confused
Thanks guys!
Chris.. try checking anything that is on all the time .. hint - internet.
Also.. An investment is probably nessesatry somewhere and so should be balanced against when it starts to pay for itself. A "boiler" comes to mind that delivers hot water instantly instead of taking a minute or so to warm up! Maybe solar panels? And I'm sure you have rooves and everything covered with heat retaining material. Are your windows double triple glazed?
Lisa
Chris.. try checking anything that is on all the time .. hint - internet.
Also.. An investment is probably nessesatry somewhere and so should be balanced against when it starts to pay for itself. A "boiler" comes to mind that delivers hot water instantly instead of taking a minute or so to warm up! Maybe solar panels? And I'm sure you have rooves and everything covered with heat retaining material. Are your windows double triple glazed?
Lisa
-
- 5StarLounger
- Posts: 964
- Joined: 08 Nov 2012, 17:54
Re: Colour me confused
Just out of interest and maybe this is off thread but I've considered that the energy thingy would be to mine the motorways. Those large pieces of moving metal should strike a chord with a lot of people. Apparently it hasn't though. And it would all be tried and tested technology as well.
Lisa
Lisa