I'm either incredibly dense, or Excel is exceedingly poorly designed, but I've been struggling for half a day to find how I can colour cells that contain the same data the same colour. The problem is that my data isn't whole numbers or percentages - it's ranges (of age and income). So I'm trying to highlight every cell that has 18-24 the same colour, for example. Every single bit of help I've found is useless. I have tried the suggestions here, and the don't work - or I don't understand them.
Could someone explain to me how to do this? And explain it without using the program language which I'm illiterate to? The talk of formulas and ranges and things goes over my head because I have no idea what it means. I just want to know what to click and what to fill in so I can get on with my work efficiently, rather than having to do every single box manually.
Keep Up with TechRepublic