Conditional Formatting...

[ChrisMattock]

I have a spreadsheet and need to peform checks to makes sure all of th
data is enetered correctly then I want the output to be a cell whic
dislpays red, amber or green depending on the status.

These are the conditions I need,

If Cell A1 < 7 then it should be red. If A1 = 7 then is should b
amber. But if A2 = 20, then it should be grren, no matter what A1 is.

Any ideas

 

[Bob Phillips]

Just use conditional formatting. Select A1 and Format>Conditional
Formatting. It is quite intuitive, apart from condition 1, where you should
change the condition to Formula Is and use a formula of =A2=20

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ChrisMattock" <[email protected]>
wrote in message
news:[email protected]...

 

[Dav]

You need to use format_conditional formating

your first conditioned needs to be the last condition you stated a
this overrides the other 2

Choose formula and put a2=20 then select green as a colour

condition2 formula a7<7 select red

Condition3 formula a7=7 select amber

Regards

Da

 

[ChrisMattock]

Brilliant, thanks

 

[Guest]

Hi Chris,


It's not clear which is your input column (cells) and which column do you
intend to color.
I suppose that you input data in A1 and want to color the same cell:

select A1
invoke Conditional formatting
1st condition: formula: =A2=20 choose green
2nd condition: cell value: less then 7 choose red
3rd condition: cell value: equals 7 choose amber

Regards,
Stefi

„ChrisMattock†ezt írta:

 

[ChrisMattock]

SOrry for the lack of clarity, the cells were just examples to b
honest, but now I know the first condition overrules the other two
have fixed the problem using the method you all suggested. Thanks all

 

[ChrisMattock]

Sorry for the lack of clarity, the cells were just examples to b
honest, but now I know the first condition overrules the other two
have fixed the problem using the method you all suggested. Thanks all

 

[sike11 via OfficeKB.com]

Hi,

Is there a way to copy this formula to other cells?
Mary.

Hi Chris,

It's not clear which is your input column (cells) and which column do you
intend to color.
I suppose that you input data in A1 and want to color the same cell:

select A1
invoke Conditional formatting
1st condition: formula: =A2=20 choose green
2nd condition: cell value: less then 7 choose red
3rd condition: cell value: equals 7 choose amber

Regards,
Stefi

„ChrisMattock” ezt írta:

I have a spreadsheet and need to peform checks to makes sure all of the
data is enetered correctly then I want the output to be a cell which

[quoted text clipped - 6 lines]

Any ideas?

 

[Bob Phillips]

Copy the format of the cells, then the others will adopt it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Hi,

Is there a way to copy this formula to other cells?
Mary.

Hi Chris,

It's not clear which is your input column (cells) and which column do you
intend to color.
I suppose that you input data in A1 and want to color the same cell:

select A1
invoke Conditional formatting
1st condition: formula: =A2=20 choose green
2nd condition: cell value: less then 7 choose red
3rd condition: cell value: equals 7 choose amber

Regards,
Stefi

„ChrisMattock” ezt írta:

I have a spreadsheet and need to peform checks to makes sure all of the
data is enetered correctly then I want the output to be a cell which

[quoted text clipped - 6 lines]

Any ideas?

 

[sike11 via OfficeKB.com]

Hi Bob,

Thanks for your response. I tried that but it did not work.

Copy the format of the cells, then the others will adopt it.

Hi,

[quoted text clipped - 23 lines]

 

[Guest]

Try using the format painter

Hi Bob,

Thanks for your response. I tried that but it did not work.

Copy the format of the cells, then the others will adopt it.

Hi,

[quoted text clipped - 23 lines]

Any ideas?

 

[sike11 via OfficeKB.com]

Hi IK,

Thanks!!! I managed to get it working!!

Try using the format painter

Hi Bob,

[quoted text clipped - 7 lines]