Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2019, 04:10 PM
p45cal's Avatar
p45cal p45cal is offline Excel Conditional Formatting Question Windows 10 Excel Conditional Formatting Question Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default


See 2 conditional formatting in columns A and E of the attached.
Attached Files
File Type: xlsx msofficeforums42919.xlsx (9.9 KB, 7 views)
Reply With Quote
  #2  
Old 07-12-2019, 04:42 AM
sjp1966 sjp1966 is offline Excel Conditional Formatting Question Windows 10 Excel Conditional Formatting Question Office 2013
Novice
Excel Conditional Formatting Question
 
Join Date: Mar 2012
Posts: 21
sjp1966 is on a distinguished road
Default

Hi, Thanks for this and I can see the conditional formatting and it does indeed work.

I am trying to understand the formula in order to learn how to do them better, no matter what cell I click in on the A Column, when I look at the formatting for that cell is says

Rule
=$E3>25%

Applies to
=$A$3:$A$12

I notice there isnt a $ to the left of the E under rule so does that mean the rule is looking always at column E but the number will change on each subsequent cell, so E4, E5, E6 etc, even though the conditional formatting on each cell only shows E3
Reply With Quote
  #3  
Old 07-12-2019, 05:51 AM
p45cal's Avatar
p45cal p45cal is offline Excel Conditional Formatting Question Windows 10 Excel Conditional Formatting Question Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by sjp1966 View Post
I notice there isnt a $ to the right of the E under rule so does that mean the rule is looking always at column E but the number will change on each subsequent cell, so E4, E5, E6 etc, even though the conditional formatting on each cell only shows E3
Yes it does.
Reply With Quote
Reply



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 09:10 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