Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
different colours for different data
hi there i have data which is either in tolerance, or out of tolerance. i need the data to be black in tolerance and red out of tolerance. in tolerance is 140.50 to 145.00 any thing else is out of tolerance. many thanks neil -- neilwebb ------------------------------------------------------------------------ neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450 View this thread: http://www.excelforum.com/showthread...hreadid=387938 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
different colours for different data
Check Data-Data Validation.
Here you can have any condition expressable in XL formulas trigger a cell format. Dm Unseen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
different colours for different data
You want conditional formatting
Look up 'Highlight cells that meet specific conditions' in the Answer wizard in help -- HTH Bob Phillips "neilwebb" wrote in message ... hi there i have data which is either in tolerance, or out of tolerance. i need the data to be black in tolerance and red out of tolerance. in tolerance is 140.50 to 145.00 any thing else is out of tolerance. many thanks neil -- neilwebb ------------------------------------------------------------------------ neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450 View this thread: http://www.excelforum.com/showthread...hreadid=387938 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I customise colours used in charts and keep those colours. | Charts and Charting in Excel | |||
How to save one of the MORE COLOURS in the THEME COLOURS? | Excel Discussion (Misc queries) | |||
how to automatically change cell colours when certain data changes | Excel Discussion (Misc queries) | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
Show data of another datasheet BY colours | Excel Programming |