Question about Microsoft Excel Computers & Internet
I have work order numbers in one column. I want the cells they are in to be highlighted bright yellow until they are completed. I will enter the completion date in another cell in the same row. Once I enter that date, I would like the highlighting in the WO cell to go away. Thanks!
Option: formula is
select formatting of choice
Highlight the order cells, go to >format>conditional formatting, choose "formula is" instead of "cell is". When you refer to the datecell, use the first date cell in the column only, and do not use $ signs.
Posted on Feb 15, 2013
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
New users get to try the service completely Free afterwhich it costs $6 per call and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
SOURCE: Conditional Formating
Use conditional formatting for the coloumn of student use Option " Formula Is" - In this write cell address of Marks e.g.c5 Then write =$c5>80 then click format and format the pattern
Posted on Oct 04, 2007
Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.
Posted on Dec 28, 2007
guess your using oldversion of outook or ms office. try to update to latest one.
or try repairing the software using your office CD. Please follow the steps it will help you to slove the issue.
Posted on Dec 30, 2008
The status bar is located at the bottom of the Excel window. It is to the left of the View buttons. If you right click, a customixe status bar menu appears and you can select what you want to show. If is does not come up, you should run Microsoft Office Diagnostics located under the Office tools menu.
Posted on Mar 22, 2009
did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.
Posted on May 10, 2009
Tips for a great answer:
Sep 16, 2014 | Microsoft Excel for PC
Feb 27, 2009 | Microsoft Office Standard for PC
Jan 03, 2009 | Microsoft Excel for PC
Dec 15, 2008 | Microsoft Windows XP Home Edition
Dec 06, 2008 | Computers & Internet
Nov 20, 2008 | Microsoft Excel for PC
Oct 04, 2017 | Microsoft Computers & Internet
Sep 13, 2017 | Microsoft Computers & Internet
49 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: