Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2014, 12:21 PM
Nate1er Nate1er is offline Conditional Formatting Issues Windows Vista Conditional Formatting Issues Office 2007
Novice
Conditional Formatting Issues
 
Join Date: Nov 2014
Posts: 1
Nate1er is on a distinguished road
Default Conditional Formatting Issues

I have a workbook I designed as my company's call log. There are 10 columns in total. The two columns I'm having issues with are the "Name" and "Follow Up" columns. I have the follow up column formatted to use a dropdown list, and then the name column is conditionally color formatted based on the text in the follow up column. I also have a filter set in the name column that I want to use to filter by name or color, etc. Also, not sure it has any affect, but my top two rows are used as 1) a color key and 2) a header row.



The problems I'm having are that when I run the filter, or when I cut & paste any data from the conditionally formatted column, my conditional formatting gets all screwed up.

So my question is: Is there a way to construct the conditional formatting formula (see below) so that running the filter or cutting & pasting doesn't affect my conditional formatting rules?

Thanks in advance for any help!

Current Conditional Formatting Rule:
Formula: =$I3="Text"
Format: Color
Applies to: $E$3:$E$10458576



Edit: Solved my own problem. Not sure if anyone else has run into this, or if maybe I was just making rookie mistakes, but here is the solution I found...

Revised Conditional Formatting Rule:
Formula: =$I3="Text"
Format: Color
Applies to: $E:$E

Last edited by Nate1er; 11-01-2014 at 12:46 PM. Reason: Solved
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Issues Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting teza2k06 Excel 3 01-19-2014 02:34 AM
Conditional Formatting Issues Conditional formatting issues sjp1966 Excel 5 02-10-2013 05:42 AM
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM
Conditional Formatting Issues Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:22 PM.


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