Help with conditional formatting in Excel 2010

[Ian R]

Hi

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.

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.

I’ve tried every which way but have got stuck and would greatly value your
input.

Thanks for your time.

Ian

 

[GS]

Ian R was thinking very hard :

Hi

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.

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.

I’ve 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!

 

[Ian R]

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

 

[Gord Dibben]

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

 

[mickrio]

I have found setting conditional formatting the way I want in Excel 200
quite easy but I’m getting tied up in knots trying t
achieve the same thin
in Excel 2010
_________
'memory foam mattress
(http://www.memoryfoammattress2u.com/memory-foam-mattresses)
'adjustable mattresses
(http://www.memoryfoammattress2u.com/adjustable-beds) | 'memory pillow
(http://www.memoryfoammattress2u.com/memory-foam-pillows

 

[GS]

Ian R submitted this idea :

"GS" wrote in message

--
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.

 

[Ian R]

"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

 

[Ian R]

"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^)

 

[Gord Dibben]

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