Posted to microsoft.public.excel.programming

Fraggs[_9_] Fraggs[_9_] is offline

external usenet poster

Posts: 1

VB - turning cells specified colours

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Turning N/A cells to blank Cells	amik	Excel Worksheet Functions	4	May 26th 09 07:30 PM
turning N/A cells to blank Cells	amik	Excel Worksheet Functions	0	May 26th 09 07:14 PM
turning a string of cells into a work shift (eg. 9am-7pm)	jbmjbj	Excel Worksheet Functions	0	January 28th 08 12:41 AM
auto-expansion of excel cells, turning it off	dan00500	Excel Discussion (Misc queries)	2	May 21st 07 06:55 PM
Excel 2003 font colours and cell colours	bretta	Excel Discussion (Misc queries)	1	April 17th 05 03:45 AM

All times are GMT +1. The time now is 10:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us