Conditional Formatting...

C

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
 
B

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

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
 
S

Stefi

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:
 
C

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
 
C

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
 
S

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
Click to expand...
[quoted text clipped - 6 lines]
Any ideas?
Click to expand...
Click to expand...
 
B

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)

sike11 via OfficeKB.com said:
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
Click to expand...
[quoted text clipped - 6 lines]
Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Top