How can I make cells turn a specified colour if certain criteria i
met.

for example if,
-1015+1015 = exactly 0, Cell turns green
else if
-1015+number = anything execpt 0, Cell turns red.

Any ideas

--
Message posted from http://www.ExcelForum.com

Have you looked at conditional formatting? I don't know how many different
scenarios you have. Conditional formatting only supports three.

"Fraggs " wrote in message
...
How can I make cells turn a specified colour if certain criteria is
met.

for example if,
-1015+1015 = exactly 0, Cell turns green
else if
-1015+number = anything execpt 0, Cell turns red.

Any ideas?


---
Message posted from http://www.ExcelForum.com/

I have 3 scenarios, 0, <0 and =0
0, <0 = Red cells
=0 = Green cells

got a link I could look at

--
Message posted from http://www.ExcelForum.com

First format your cells to be green.

Then select your cells then from the Format menu, choose Conditional
formatting. Set up the first format with Not Equal To 0 and then click
the format button and select Red.

It's pretty self-explanatory.

K


---
Message posted from http://www.ExcelForum.com/

In Excel

Click on Format

Conditional Formatting

Set your first condition.

Click Add

Set your second condition.

Click Add

Set your third condition.

Click OK



"Fraggs " wrote in message
...
I have 3 scenarios, 0, <0 and =0
0, <0 = Red cells
=0 = Green cells

got a link I could look at?


---
Message posted from http://www.ExcelForum.com/

Does it have to be with VB code ? Conditional formatting (Format menu) is
far easier.

Why are so many newsgroup postings channeled through Excelforum saying "any
ideas?" by the way ?
--
HTH. Best wishes Harald
Followup to newsgroup only please

"Fraggs " skrev i melding
...
How can I make cells turn a specified colour if certain criteria is
met.

for example if,
-1015+1015 = exactly 0, Cell turns green
else if
-1015+number = anything execpt 0, Cell turns red.

Any ideas?


---
Message posted from http://www.ExcelForum.com/

Why are so many newsgroup postings channeled through Excelforum saying
"any ideas"?

Huh? I just said any ideas at the end cos I was clueless and it leaves
the question more open than saying, only people who deffinatly know how
to solve this answer me. I'm open to all and any suggestions.


---
Message posted from http://www.ExcelForum.com/

Take a look at "conditional formating". You should be
able to accomplish what you want.

Byron

-----Original Message-----
How can I make cells turn a specified colour if certain
criteria is
met.

for example if,
-1015+1015 = exactly 0, Cell turns green
else if
-1015+number = anything execpt 0, Cell turns red.

Any ideas?


---
Message posted from http://www.ExcelForum.com/

.