Excel - using colour in cell range

  Squash01 19:25 23 Sep 04
Locked

Can anyone help. I am trying to use different colours to identify data in a range of cells. The data is numeric and the colours are specific to the data. i.e yellow identifies gas bill blue electric bill green shopping and so on. Although I can create a macro for this exercise I cannot find the formula. All the data will be in one colunm and the total spend would be referenced in a single cell.

  VoG II 19:28 23 Sep 04

Is there another column containing "Gas", "Electric", "Shopping" and so on?

If so, you can use Conditional Formatting of the numeric cells, using the Formula Is option (drop down on the dialog box) and referring to the "Gas" etc. entries.

This thread is now locked and can not be replied to.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes