Excel - using colour in cell range

  Squash01 19:25 23 Sep 2004
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 2004

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.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Is this the future of VR and AR?

Best iPad buying guide 2017

Comment regarder le Bureau des L├ęgendes en ligne ?