Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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

Conditional Formatting...
 

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