Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page colour codeing a cell by entering data colour codeing a cell by entering data
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 05-29-2014, 07:39 AM
OTPM OTPM is offline colour codeing a cell by entering data Windows 7 32bit colour codeing a cell by entering data Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Yes it is possible :-).
Reply With Quote
  #2  
Old 05-29-2014, 07:40 AM
OTPM OTPM is offline colour codeing a cell by entering data Windows 7 32bit colour codeing a cell by entering data Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi
You can use Conditional formatting to do this.
Hope this helps.
Tony
Reply With Quote
  #3  
Old 05-29-2014, 08:06 AM
gazza uk gazza uk is offline colour codeing a cell by entering data Windows 8 colour codeing a cell by entering data Office 2010 32bit
Novice
colour codeing a cell by entering data 		 
Join Date: May 2014
Location: uk
Posts: 4
gazza uk is on a distinguished road
Default it says
I get the message saying

you cannot use references to other worksheets or workbook for conditional formatting criteria
Reply With Quote
  #4  
Old 05-29-2014, 08:47 AM
gazza uk gazza uk is offline colour codeing a cell by entering data Windows 7 32bit colour codeing a cell by entering data Office 2007
Novice
colour codeing a cell by entering data 		 
Join Date: May 2014
Location: uk
Posts: 4
gazza uk is on a distinguished road
Default wrong excel virsion
could it be because I am using excel 2007 not 2010 as I stated ??
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to immediately change the colour of a cell depending on the code placed in anothe Phil Payne Excel Programming 2 07-27-2013 11:04 PM
colour codeing a cell by entering data Quadrant colour based on cell value RoyLittle0 Excel 2 05-05-2013 12:50 AM
colour codeing a cell by entering data entering data in separate rows within a cell drsuis Excel 1 02-19-2013 04:36 PM
CHange colour of footer if a cell changes to red OTPM Excel 0 05-26-2011 07:15 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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