Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2017, 07:39 AM
Grubermen Grubermen is offline If text in column then formula in other Windows 7 64bit If text in column then formula in other Office 2013
Novice
If text in column then formula in other
 
Join Date: Aug 2017
Posts: 1
Grubermen is on a distinguished road
Default If text in column then formula in other

I am tying to make a column change text and background colors only if certain text is present n column A. So I have in Column A the states (ND, WY). Under Column H I have dates of training. I know how to use conditional formatting to have rows change colors when 30 days out and when expired. I would like to add the rule based on text in column A. Expiration only applies in ND. I have tried but cant get it to work. Thanks for any help.
Reply With Quote
  #2  
Old 09-06-2017, 06:35 AM
Trevor G Trevor G is offline If text in column then formula in other Windows Vista If text in column then formula in other Office 2007
Novice
 
Join Date: May 2012
Posts: 9
Trevor G is on a distinguished road
Default

You would need to use formula IF AND to meet the 2 conditioins.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to put a formula in a table column header to define the name of the column? JacquesW Excel 3 05-08-2017 08:00 AM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
If text in column then formula in other Parsing 'FullName' column - help needed text to column ScottA Excel Programming 3 05-06-2014 12:49 PM
formula to work from data column masterdineen Excel 16 08-09-2012 07:52 AM
Formula not getting copied to entire column theacegary Excel 1 11-29-2010 02:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 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