Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-04-2014, 08:17 AM
sky474 sky474 is offline How to change the font color of cell values Windows XP How to change the font color of cell values Office 2007
Novice
How to change the font color of cell values
 
Join Date: Mar 2014
Posts: 8
sky474 is on a distinguished road
Default How to change the font color of cell values


I have around 400 values in each cell A2 and A3. Now I want to change the font color of each values in A3 based on values in A2 with some conditions. If the value in A3 is equal to value in A2 then color should be black, if value in A3 is greater than A2 then color should be red and if value in A3 is less than A2 then color should be green.
Can it be done with Conditional Formatting?
If yes, then please tell me how to do it?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word macro doesn't change font color Spideriffic Word VBA 8 11-04-2015 03:47 AM
Change Cell Color Based On % Complete jrfoley3 Project 1 05-30-2013 05:24 AM
how to search and replace BOLD text >> font color change? dylansmith Word 4 03-12-2013 09:51 PM
How to change the font color of cell values change default font color to wdRed tinfanide Word VBA 6 06-07-2012 06:48 AM
change values based on cell ubns Excel 1 05-21-2012 06:28 PM

Other Forums: Access Forums

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