Also is it possible to increase the number of conditional formats on any one
cell from 3
--
Cheers

Maggie


"Maggie" wrote:

Hi

How can I type a value in one cell in a column and automatically colour fill
cells in a range of columns on the same row when this change takes place,
there needs to be an if statement somewhere I think because if the cell = a
all else is blue, if cell = b all else is red etc.
--
Cheers

Maggie