Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-14-2013, 09:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Cell Background Color:  Base it on Content of Cell? Windows 7 64bit Cell Background Color:  Base it on Content of Cell? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Seven does not seem to be undo-able
Select your range - Home Ribbon- Conditional formatting - New rule - Use a formula - Enter =$A1="red" and format as needed
Do the same for the others always using $A1 ( if col A of course, otherwise, adapt as needed)

You could probably find more explanation on YouTube or similar sites
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Background Color:  Base it on Content of Cell? How to add background CELL image rosede Word Tables 2 11-15-2012 07:08 AM
How can I delete the content of a cell in column if the cell value is more than 1000? Learner7 Excel 2 06-27-2011 05:44 AM
Cell Background Color:  Base it on Content of Cell? Cell content splits Mahen Excel 2 05-15-2011 01:53 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM

Other Forums: Access Forums

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