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
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 be
amber. But if A2 = 20, then it should be grren, no matter what A1 is.

Any ideas?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556373

Just use conditional formatting. Select A1 and FormatConditional
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"
wrote in message
news:ChrisMattock.2a3uis_1151485860.0431@excelforu m-nospam.com...

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
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 be
amber. But if A2 = 20, then it should be grren, no matter what A1 is.

Any ideas?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile:
http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556373

You need to use format_conditional formating

your first conditioned needs to be the last condition you stated as
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

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=556373

Brilliant, thanks!


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556373

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
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 be
amber. But if A2 = 20, then it should be grren, no matter what A1 is.

Any ideas?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556373

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


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556373

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


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556373

Hi,

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

Stefi wrote:
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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1

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)

"sike11 via OfficeKB.com" <u21678@uwe wrote in message
news:6271f95e55990@uwe...
Hi,

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

Stefi wrote:
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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1

Hi Bob,

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

Bob Phillips wrote:
Copy the format of the cells, then the others will adopt it.

Hi,

[quoted text clipped - 23 lines]

Any ideas?

--
Message posted via http://www.officekb.com

Try using the format painter

"sike11 via OfficeKB.com" wrote:

Hi Bob,

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

Bob Phillips wrote:
Copy the format of the cells, then the others will adopt it.

Hi,

[quoted text clipped - 23 lines]

Any ideas?

--
Message posted via http://www.officekb.com

Hi IK,

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

lk wrote:
Try using the format painter

Hi Bob,

[quoted text clipped - 7 lines]

Any ideas?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1