Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2009, 01:53 PM
Silver Rain 007 Silver Rain 007 is offline Need cells to autofill with color Windows 7 Need cells to autofill with color Office 2007
Novice
Need cells to autofill with color
 
Join Date: Oct 2009
Posts: 1
Silver Rain 007 is on a distinguished road
Default Need cells to autofill with color

Okay, so I have this data and its a bunch of different categories and each line item has notes with it in a separate cell as text. The entire spreadsheet is replaced everyday but many of the same items exist.



I know I can make a separate worksheet, put the notes on that spreadsheet and VLookup them to a specific combination of Account number and Transaction date. So that Note A autofills in the line with the account number "XYZ" and Transaction Date "X/Y/ZZZZ". (Any help on the VLookup Formula bring it on! We are talking about thousands of lines or I'd just if statement it) But I'd also like for that cell to autofill with a specific color. So at a glance someone could see that "Oh this is a green note, this means X" without having to necessarily read the detail. I imagine it maybe could be done with something like =if(Cell)="text" color Blue but I don't know how to get something to color that way or if its even possible. Thank you so much!
Reply With Quote
  #2  
Old 10-22-2009, 08:19 PM
PKTEE PKTEE is offline Need cells to autofill with color Windows XP Need cells to autofill with color Office 2003
Novice
 
Join Date: Aug 2009
Posts: 9
PKTEE is on a distinguished road
Wink Need cells to autofill with color

Use Conditional Formatting to autofill cell with color
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need cells to autofill with color Change color of text in bullets franklyorange PowerPoint 2 06-22-2010 04:51 AM
Color control for tracking changes derohanes Word 0 08-11-2009 08:37 AM
Need cells to autofill with color Extracting Cell color bsaucer Excel 1 06-19-2009 06:52 AM
need help with font color samsongee Word 0 09-07-2006 10:18 PM
color issues when making a pdf matt Publisher 0 03-10-2006 08:16 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:48 PM.


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