#1
|
|||
|
|||
What formula should I use?
Good day. I'm new to this forum and somewhat new to excel. I did some project for my school but they were basic with no complications really.
My question is what function should I use so that specific row with information in 'F Colum' light up in red or yellow colors. For example my F Colum will contain 'NOT' or 'Later' and will be selected from drop down list. I would want my NOT to be in red and Later in Yellow. Sorry if I missed anything to help you better understand this. Please let me know if any addition information is needed. Thank you in advance. |
#2
|
||||
|
||||
Sounds to me like you want "conditional formatting". I don't use it very often, just enough to look it up when I want it, and the way it works has changed from Excel 2003 to 2010. But if you look it up in the Help files, maybe "conditional formatting" will get you to all the information you need.
If not, someone else here will be able to get into details with you. I think Pecoflyer is pretty familiar with it. |
#3
|
|||
|
|||
CF
Rule 1: =$F1="Later" Rule 2: =$F1="NOT" |
#4
|
|||
|
|||
Could you please explain to me step by stem I need to take?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with a formula | e_a_g_l_e_p_i | Excel | 14 | 02-07-2013 12:37 AM |
formula help | rich_cirillo | Excel | 3 | 09-26-2012 11:41 PM |
formula help | excelledsoftware | Excel | 8 | 03-25-2012 08:49 AM |
Help with Formula | Corca | Excel | 6 | 02-22-2010 09:40 PM |
If formula | sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |