Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2013, 01:12 PM
TotalONE TotalONE is offline What formula should I use? Windows 8 What formula should I use? Office 2013
Novice
What formula should I use?
 
Join Date: Nov 2013
Posts: 3
TotalONE is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-22-2013, 09:37 PM
BobBridges's Avatar
BobBridges BobBridges is offline What formula should I use? Windows 7 64bit What formula should I use? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 11-22-2013, 11:46 PM
Kevin@Radstock Kevin@Radstock is offline What formula should I use? Windows 8 What formula should I use? Office 2013
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

CF

Rule 1: =$F1="Later"

Rule 2: =$F1="NOT"
Reply With Quote
  #4  
Old 11-26-2013, 01:30 PM
TotalONE TotalONE is offline What formula should I use? Windows 8 What formula should I use? Office 2013
Novice
What formula should I use?
 
Join Date: Nov 2013
Posts: 3
TotalONE is on a distinguished road
Default

Could you please explain to me step by stem I need to take?


Quote:
Originally Posted by Kevin@Radstock View Post
CF

Rule 1: =$F1="Later"

Rule 2: =$F1="NOT"
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
What formula should I use? Need help with a formula e_a_g_l_e_p_i Excel 14 02-07-2013 12:37 AM
What formula should I use? formula help rich_cirillo Excel 3 09-26-2012 11:41 PM
What formula should I use? formula help excelledsoftware Excel 8 03-25-2012 08:49 AM
What formula should I use? Help with Formula Corca Excel 6 02-22-2010 09:40 PM
What formula should I use? If formula sixhobbits Excel 1 10-02-2009 08:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:05 AM.


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