#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Need cells to autofill with color
Use Conditional Formatting to autofill cell with color
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |