Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2010, 12:38 PM
Scaffold Scaffold is offline Conditional formatting of cell, Excel 2003 Windows Vista Conditional formatting of cell, Excel 2003 Office 2007
Advanced Beginner
Conditional formatting of cell, Excel 2003
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default Conditional formatting of cell, Excel 2003

How to make the cell look different bases on the result of the formula?
There is something in the help for 2003 about it, but that is truly incomprehensible!
For instance, I would like to get the cell to have green background if result is TRUE and red one if result is FALSE. If not the background, the font colour will do.
Reply With Quote
  #2  
Old 04-22-2010, 10:42 AM
xxsawer xxsawer is offline Conditional formatting of cell, Excel 2003 Windows XP Conditional formatting of cell, Excel 2003 Office 2003
Novice
 
Join Date: Apr 2010
Posts: 21
xxsawer is on a distinguished road
Default

Incomprehensible?
Simply use Format - Conditional formating and set what you want
Reply With Quote
  #3  
Old 05-01-2010, 08:56 AM
Kristiina's Avatar
Kristiina Kristiina is offline Conditional formatting of cell, Excel 2003 Windows Vista Conditional formatting of cell, Excel 2003 Office 2007
Advanced Beginner
 
Join Date: Apr 2010
Posts: 58
Kristiina is on a distinguished road
Default

In order to get the conditional formatting to work you have to first select the data you wish to format and then choose the conditional formatting button. From the second list choose "Equals to" and type for an example TRUE. From the "Format" button choose the color of your liking. To get the tool to color the "FALSE" cells in a different color, choose the conditional formatting again and do the same procedure all over except next to "Equals to" type FALSE.

Hope this helps.

Rgrds,
Kristiina
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 formatting issue when moving to new WB aramsey Excel 2 04-22-2010 02:34 PM
Challenge!! Need help though. (Conditional formatting) knuckles70 Excel 2 02-05-2010 12:24 PM
Conditional Text Adding - Word 2003 chuck Mail Merge 0 06-17-2009 08:09 AM
Conditional formatting of cell, Excel 2003 Cell formatting Niko Excel 5 04-23-2009 12:05 AM
Conditional Formatting to Hide Rows or Columns? sczegus Excel 0 09-26-2006 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft