Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 07-11-2019, 02:50 AM
ArviLaanemets ArviLaanemets is offline Excel Conditional Formatting Question Windows 8 Excel Conditional Formatting Question Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

The formula is entered as conditional formatting rule condition, not into worksheet cell! Select the range with data (e.g. A3:A12), then activate Home menu, select Conditional Formatting and then New Rule (or when some rules are defined, then Manage Rules). For new rule select Use a Formula ... - and now enter the condition formula for left topmost cell of selection (be aware of use $ signs for cell references - in your case it must be $CR, like $E3). Then click Format and set there how cell is displayed when the condition is TRUE, and press OK until done!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Conditional Formatting Question Conditional Formatting deleted by excel when saving and reopening file sazetts Excel 7 02-09-2017 10:52 AM
Excel Conditional Formatting Question Question re: Conditional formatting (cell occurs after another cell) Saywarder Excel 1 04-20-2015 11:29 AM
Excel Conditional Formatting Question Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM
Conditional Formatting Problem Excel 2007 namedujour Excel 6 08-04-2011 10:52 AM
Excel Conditional Formatting Question Conditional formatting of cell, Excel 2003 Scaffold Excel 2 05-01-2010 08:56 AM

Other Forums: Access Forums

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