Solved

Excel Is not applying "Highlight Cells Rule" properly

Posted on 2014-09-06
4
220 Views
Last Modified: 2014-09-16
Hi Everyone,

I have an excel sheet with 3 columns. the purpose of this sheet is to show the required amount of time between Departure and Arrival, and that where the 3rd column comes to picture (Duration column).

Departure, Arrival and Duration column are set as TIME cells and formatted in 24 hour .I also applied a Highlight Cells Rule on the "DURATION column" which will highlight any cell with specific time (ex. 6min or less )with any color i select.

The issue am facing is that excel is not applying the rule on all the cells but instead some cells remain the same although they fall under the rule.

Regards,Highlight-rule.PNG
0
Comment
Question by:Khalifa_Alshamsi
  • 2
4 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 40307648
Can you paste a screen clip of your rule please.
0
 
LVL 2

Accepted Solution

by:
DanielT earned 500 total points
ID: 40307682
Be sure you have no formats set manually on the cells that may confuse auto-formatting rule results.

Check your formula to ensure that references are not $A$1 for instance as is a default. You'll need to edit this to allow the reference to "move". For example - manually edit the rule and change the reference of $A$1 to $A1 to maintain same column but allow row to be referenced to new row data.

Hope this makes sense...
0
 

Author Comment

by:Khalifa_Alshamsi
ID: 40309176
@ Neilsr, find the excel attached

@DanielT, your solution worked once only. any suggestion to be able to apply it on the whole column.
0
 
LVL 2

Expert Comment

by:DanielT
ID: 40309636
The rule will apply to what your selection range is. Select the entire column - or just the range for the rule. Then ensure your rule is formatted as per last post. You should also be able to "manage" rules and change the range it applies to.

Just be careful of references so they can "move" with the rule. Excel likes to change them with it's own assumptions!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question