You could use conditional formatting:-

Select as many cells as you want in row 1 from column B. Then
Format|Conditional Format
Select formula is and enter this formula:-
=$A1="A"
Select a cloour.
Click Add and add additional formula
=$A1="B" and select another colour
Click OK
Enter A or B in A1 to change the colour of the row.

Mike


"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