Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2017, 07:59 AM
xor xor is offline Conditional Formating? Windows 10 Conditional Formating? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default


Select the cell you already have conditionally formatted.
Press Conditional Formatting and then Manage Rules. In the field 'Applies to' write the range with all your columns. OK.
Reply With Quote
  #2  
Old 12-13-2017, 08:38 AM
wilabern wilabern is offline Conditional Formating? Windows 7 64bit Conditional Formating? Office 2013
Novice
Conditional Formating?
 
Join Date: Dec 2017
Posts: 7
wilabern is on a distinguished road
Default

The problem is the formatting of column D is dependent on the letter in cell D11, Column E is dependent on the letter in cell E11, and Column F on the letter in F11. If I just tell the conditional formatting to apply to all cells in column D,E, and F, it will base the conditional formatting of Column E and F on the letter in cell D11.
Attached Images
File Type: png formatting example.PNG (10.3 KB, 20 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating? Conditional formating MJS16 Excel 16 12-01-2016 01:09 PM
Conditional Formating MaineLady Excel 2 10-30-2016 02:08 PM
Conditional Formating? Conditional Formating Aseren Excel 14 02-18-2016 01:05 PM
Conditional Formating MaineLady Excel 1 11-05-2014 06:37 PM
Conditional Formating? more Conditional Formating princeofsadness Excel 2 09-05-2011 02:14 AM

Other Forums: Access Forums

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