Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How to change the colour of a cell How to change the colour of a cell
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2018, 05:00 PM
Goozzie Goozzie is offline How to change the colour of a cell Windows 7 64bit How to change the colour of a cell Office 2013
Novice
How to change the colour of a cell 		 
Join Date: Aug 2015
Posts: 3
Goozzie is on a distinguished road
Exclamation How to change the colour of a cell
eg if cell A1=5 then change the colour of cell A1 to green.

Has anyone got any examples of such a formula?



Regards

Goozzie
Reply With Quote
  #2  
Old 03-17-2018, 01:08 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to change the colour of a cell Windows 7 64bit How to change the colour of a cell Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
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
Hi
hit F1 and search for " conditional formatting"
__________________
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
  #3  
Old 03-17-2018, 03:00 AM
Goozzie Goozzie is offline How to change the colour of a cell Windows 7 64bit How to change the colour of a cell Office 2013
Novice
How to change the colour of a cell 		 
Join Date: Aug 2015
Posts: 3
Goozzie is on a distinguished road
Default Solved
Thanks Pecoflyer
Reply With Quote
  #4  
Old 03-17-2018, 07:11 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to change the colour of a cell Windows 7 64bit How to change the colour of a cell Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
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
Most welcome
__________________
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
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Text Colour in Cell Based on Text in Same Cell PMC11 Word VBA 1 11-14-2017 09:15 PM
How to change the colour of a cell Change of colour of Email mravimtnl Outlook 2 04-03-2017 02:10 AM
How to change the colour of a cell Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow FUGMAN Excel Programming 7 02-05-2017 08:37 AM
VBA to immediately change the colour of a cell depending on the code placed in anothe Phil Payne Excel Programming 2 07-27-2013 11:04 PM
CHange colour of footer if a cell changes to red OTPM Excel 0 05-26-2011 07:15 AM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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