If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formating
Can I use conditional formatting so as to look at Column A
A1 a2 A2 Turns EA 1.00 red CS 100 Blue BX 50 Green I have columns with 1000's of entries, and I may change column A1 entries often. Thanks in advance Harry |
#2
|
|||
|
|||
Sure, select column A, goto FormatConditional Formatting
Change Condition to Formula Is Input a formula of A1=1 Click Format, select the pattern tab and choose Red OK Add condition Change Condition to Formula Is Input formula of A1=50 Click Format, select the pattern tab and choose Green OK Add condition Change Condition to Formula Is Input formula of A1=100 Click Format, select the pattern tab and choose Blue OK OK -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Can I use conditional formatting so as to look at Column A A1 a2 A2 Turns EA 1.00 red CS 100 Blue BX 50 Green I have columns with 1000's of entries, and I may change column A1 entries often. Thanks in advance Harry |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formating in Report Header | Haas | Setting Up & Running Reports | 1 | July 21st, 2004 10:50 PM |
Conditional Formating Limits | DMP | Worksheet Functions | 18 | July 14th, 2004 02:04 PM |
conditional formating | amit | Worksheet Functions | 2 | March 2nd, 2004 03:02 PM |
Conditional Formating | Brw | Worksheet Functions | 3 | December 9th, 2003 03:12 PM |