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

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

Format/ Conditional Formatting/ Formula Is:
continue as appropriate (with suitable choices of absolute and relative
addressing) ...
--
David Biddulph

"Maggie" wrote in message
...
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

Hi Guys
Thanks for this it works well. Now how can I copy it from one rown to the
next (dragging does not work)
--
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

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

Hi Maggie,

highlight the cells that you currently have this applied to on row 1
and double-click the Format Painter icon - then you can just click on
the first cell of the next row you want this to apply to, then the
next row etc - press <Esc when you are done.

Hope this helps.

Pete

On Nov 28, 1:32 pm, Maggie wrote:
Hi Guys
Thanks for this it works well. Now how can I copy it from one rown to the
next (dragging does not work)
--
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- Hide quoted text -

- Show quoted text -

This is the limit that applies in Excel 2003 and earlier - you can
have more conditions per cell in Excel 2007.

You will need a macro if you want to increase the limit in earlier
versions - Bob Phillips has an add-in, CFPlus, which you can download
from he

http://www.xldynamic.com/source/xld.....Download.html

This allows up to 30 conditions.

Hope this helps.

Pete

On Nov 28, 1:33 pm, Maggie wrote:
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- Hide quoted text -

- Show quoted text -

Hi Pete
Thanks for this link, unfortunately it does not work, it does create the add
in in excel toolbar but then does not work from there. There is more than
one download - do you know which I should use?

--
Cheers

Maggie


"Pete_UK" wrote:

This is the limit that applies in Excel 2003 and earlier - you can
have more conditions per cell in Excel 2007.

You will need a macro if you want to increase the limit in earlier
versions - Bob Phillips has an add-in, CFPlus, which you can download
from he

http://www.xldynamic.com/source/xld.....Download.html

This allows up to 30 conditions.

Hope this helps.

Pete

On Nov 28, 1:33 pm, Maggie wrote:
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- Hide quoted text -

- Show quoted text -

I haven't used it, so I can't advise further.

You could leave a message on the website - I know that Bob Phillips is
currently involved in the Excel Users Conference, so he won't be able
to get back to you until Saturday.

Hope this helps.

Pete

On Nov 29, 8:05 am, Maggie wrote:
Hi Pete
Thanks for this link, unfortunately it does not work, it does create the add
in in excel toolbar but then does not work from there. There is more than
one download - do you know which I should use?

--
Cheers

Maggie



"Pete_UK" wrote:
This is the limit that applies in Excel 2003 and earlier - you can
have more conditions per cell in Excel 2007.

You will need a macro if you want to increase the limit in earlier
versions - Bob Phillips has an add-in, CFPlus, which you can download
from he

http://www.xldynamic.com/source/xld.....Download.html

This allows up to 30 conditions.

Hope this helps.

Pete

On Nov 28, 1:33 pm, Maggie wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Did you "launch cfplus" from the xldTools menu item?


Gord Dibben MS Excel MVP

On Thu, 29 Nov 2007 00:05:00 -0800, Maggie
wrote:

Hi Pete
Thanks for this link, unfortunately it does not work, it does create the add
in in excel toolbar but then does not work from there. There is more than
one download - do you know which I should use?

--
Cheers

Maggie