Hi

I have found setting conditional formatting the way I want in Excel 2003
quite easy but Im getting tied up in knots trying to achieve the same thing
in Excel 2010.

Simply put, I want the fill colour of a row to change depending on the text
value of column A in that row.

I have a data set spanning columns A to J and rows 3 to 50

Col A will contain the criteria text PAID or UNPAID or CHECK as required

So if A3 says €œPAID€� then A3 to J3 has a blue fill, or if A3 says €œUNPAID€�
then A3 to J3 has a RED fill or if A3 says €œCheck€� then A3 to J3 has a green
fill
and I want this to continue down through the rows according to the text in
col A.

I hope this is clear.

Ive tried every which way but have got stuck and would greatly value your
input.

Thanks for your time.

Ian

Ian R was thinking very hard :
Hi

I have found setting conditional formatting the way I want in Excel 2003
quite easy but Im getting tied up in knots trying to achieve the same thing
in Excel 2010.

Simply put, I want the fill colour of a row to change depending on the text
value of column A in that row.

I have a data set spanning columns A to J and rows 3 to 50

Col A will contain the criteria text PAID or UNPAID or CHECK as required

So if A3 says €œPAID€� then A3 to J3 has a blue fill, or if A3 says €œUNPAID€�
then A3 to J3 has a RED fill or if A3 says €œCheck€� then A3 to J3 has a green
fill
and I want this to continue down through the rows according to the text in
col A.

I hope this is clear.

Ive tried every which way but have got stuck and would greatly value your
input.

Thanks for your time.

Ian

So what you want to do is set up 3 conditions. The 1st condition to
evaluate 'TRUE' wins!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

"GS" wrote in message ...



So what you want to do is set up 3 conditions. The 1st condition to
evaluate 'TRUE' wins!

--
Garry

===============


Hi Garry

Thanks for replying.

I have set up the 3 conditions which work fine but only in Col A. The
formatting is not being applied across the row from Col A thru to J.

This is where I'm stuck as I'm not sure where I'm going wrong.

Do you have any suggestions on what I can check to see why it not happening
in the other columns?

Thanks again for your time.

Regards

Ian

Preselect A through J for as many rows as you would be using.

For example select A1:J100

Set up your conditions for Column A like Use a Formula =$A1="Paid"

then format and =$A1="Unpaid" then format

Make sure you use the $ sign as I have shown which locks the column
but allows the row to increment down to row 100


Gord

On Sun, 12 Feb 2012 23:26:29 -0000, "Ian R" wrote:

Thanks for replying.

I have set up the 3 conditions which work fine but only in Col A. The
formatting is not being applied across the row from Col A thru to J.

This is where I'm stuck as I'm not sure where I'm going wrong.

Do you have any suggestions on what I can check to see why it not happening
in the other columns?

Thanks again for your time.

Regards

Ian

I have found setting conditional formatting the way I want in Excel 2003
quite easy but I€™m getting tied up in knots trying to achieve the same thing
in Excel 2010.
__________
memory foam mattress | adjustable mattresses | memory pillow

Ian R submitted this idea :

"GS" wrote in message ...



So what you want to do is set up 3 conditions. The 1st condition to
evaluate 'TRUE' wins!

--
Garry

===============


Hi Garry

Thanks for replying.

I have set up the 3 conditions which work fine but only in Col A. The
formatting is not being applied across the row from Col A thru to J.

This is where I'm stuck as I'm not sure where I'm going wrong.

Do you have any suggestions on what I can check to see why it not happening
in the other columns?

Thanks again for your time.

Regards

Ian

As Gord suggests, you MUST use formulas AND the ref to column A MUST be
absolute. If you did not prefix A with the $ character then your other
columns are referencing themselves and not column A. Clicking on any
cell in B:J and opening the CF dialog should reveal what's wrong.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

"Gord Dibben" wrote in message
...

Preselect A through J for as many rows as you would be using.

For example select A1:J100

Set up your conditions for Column A like Use a Formula =$A1="Paid"

then format and =$A1="Unpaid" then format

Make sure you use the $ sign as I have shown which locks the column
but allows the row to increment down to row 100


Gord
=============================

Gord

Thank you very much. That was just what I needed.

Ive now got it working exactly how I want it.

Cheers

Ian

"GS" wrote in message ...


As Gord suggests, you MUST use formulas AND the ref to column A MUST be
absolute. If you did not prefix A with the $ character then your other
columns are referencing themselves and not column A. Clicking on any
cell in B:J and opening the CF dialog should reveal what's wrong.

--
Garry

=========================

Hi Garry

Thanks again.

Yes that's what I was missing and I can see the difference it makes now.

Cheers

Ian I^)

Good to hear.

Thanks for the feedback.

You can learn more about the usage of the $ signs by looking at
relative and absolute cell addresses in help.


Gord

On Tue, 14 Feb 2012 00:25:52 -0000, "Ian R" wrote:



"Gord Dibben" wrote in message
.. .

Preselect A through J for as many rows as you would be using.

For example select A1:J100

Set up your conditions for Column A like Use a Formula =$A1="Paid"

then format and =$A1="Unpaid" then format

Make sure you use the $ sign as I have shown which locks the column
but allows the row to increment down to row 100


Gord
=============================

Gord

Thank you very much. That was just what I needed.

Ive now got it working exactly how I want it.

Cheers

Ian