Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 09-24-2018, 11:50 AM
jeffreybrown jeffreybrown is offline Cell color based on cell value as compared to another cell va Windows Vista Cell color based on cell value as compared to another cell va Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

I imagine you are speaking about the last post which seems overkill to me. Why create a column (column E) of formulas to do the conditional formatting when you can apply the condition directly to the cells.

Maybe looking at some tutorials will help...

https://exceljet.net/conditional-for...-with-formulas
https://www.contextures.com/xlCondFormat03.html
https://www.ablebits.com/office-addi...matting-dates/

These are just a few tutorials pasted around the internet. We could retype these steps, but since they are already typed out and not exactly sure what you are understanding, there should help.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell color based on cell value as compared to another cell va looking to change cell color by typing number into the cell ibs Word Tables 1 11-22-2016 06:31 PM
Cell color based on cell value as compared to another cell va Entering a number in a cell causes it to fill with the color of a nearby cell Bill Martz Excel 1 04-23-2015 07:57 PM
Cell color based on cell value as compared to another cell va Cell Background Color: Base it on Content of Cell? tatihulot Excel 4 08-14-2013 03:24 PM
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 07:46 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