Conditional formatting (Excel)

CFA General
#1

I’m currently in the process of “making pretty” a number of workbooks and have been using the conditional formatting solution in Excel, which makes various cells turn different colours dependent on values entered into them. This is very simple and quite effective - however the maximum number of conditions that can be applied is 3 and I’d like to increase this to 9 in order to fit the purpose of this exercise. Can anyone help (either through formulae, VBA or pure Excel trickery) to make this happen? Cheers, JT

#2

I know this can be done in 2007 but I think in 2003 you’d need to use VBA.

#3

here is an outline of the code you’d need: http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm

#4

KrukVT - thanks very much. JT