Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-21-2013, 10:02 AM
bremen22 bremen22 is offline Contional Formating Windows 7 64bit Contional Formating Office 2007
Advanced Beginner
Contional Formating
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Question Contional Formating

Good Afternoon,



I am trying to add some conditional formatting to a sheet and it is not exactly going as planned.

I have three conditions that will cause an entire row to be highlighted. I am running into an issue where one of my conditions is causing my header row to also change color. Here is what I am trying to accomplish

if T=Recevied then turn the row green
if T=On the Way then turn it red.

Those are the easy ones and work fine. The third condition is throwing the wrench in the works.

if T=On the Way and P has a number in it (the waybill) then turn it yellow.

I tried playing with the order and the "Stop if true" check box. Either my header turns yellow or my Received Items turn yellow.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Contional Formating Need help formating a object csurocker Word 5 10-18-2013 03:35 AM
Formating for buletts YooNaa Kim Word 5 05-04-2012 11:49 PM
Contional Formating more Conditional Formating princeofsadness Excel 2 09-05-2011 02:14 AM
After formating PC milkmile Outlook 2 10-12-2010 06:58 AM
Formating headline andrejanubis Word 0 07-29-2009 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 PM.


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