Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2014, 11:52 AM
genevievebr0 genevievebr0 is offline Urgent - Don't know how to do Conditional formatting rules Windows 7 64bit Urgent - Don't know how to do Conditional formatting rules Office 2010 64bit
Novice
Urgent - Don't know how to do Conditional formatting rules
 
Join Date: Aug 2014
Posts: 17
genevievebr0 is on a distinguished road
Default

Hmmm, not sure it would be possible. The table is already very wide. Is it possible to click on a conditional format rule and ask them to identify the cells? If so, I could do this for a couple of rules.

Another idea. Number all the issues. For all conditional rules found in a row, have the number of the issue written at the end of the report. For example, rule 3, 7 and 12 apply. These numbers would be entered in column AM, AN and AO. What do you think?
Reply With Quote
  #2  
Old 08-07-2014, 12:12 PM
gebobs gebobs is offline Urgent - Don't know how to do Conditional formatting rules Windows 7 64bit Urgent - Don't know how to do Conditional formatting rules Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by genevievebr0 View Post
Hmmm, not sure it would be possible. The table is already very wide.
The columns don't need to be wide if we make one for each code. Just wide enough to fit a single character.

Alternatively, we could make it one column and have an equation enter a code for each error encountered. Thus the cell error codes might look like "999L01 99P02 CNH CONV" or "1 3 6 12" or however you might like to code your errors.

Also, we could make an entirely new tab for the errors.

Quote:
Another idea. Number all the issues. For all conditional rules found in a row, have the number of the issue written at the end of the report. For example, rule 3, 7 and 12 apply. These numbers would be entered in column AM, AN and AO. What do you think?
Precisely how I described one solution above. Great minds think alike. Fortunately, so do we. ;-)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent - Don't know how to do Conditional formatting rules 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
Creating multiple conditional rules on one column secoo140 Excel 0 10-07-2013 12:13 PM
URGENT!!! Powerpoint Image Formatting and Positioning Macro mertulufi PowerPoint 5 12-20-2011 10:14 AM
Urgent - Don't know how to do Conditional formatting rules Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.


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