Computers & Internet Logo

Related Topics:

Anonymous
Anonymous Posted on Jan 09, 2013
Answered

Excel Conditional Formatting: how do I make one cell highlight based on whether or not another cell is blank?

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!

Answer This Question

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.
New Friend:

An expert that has 1 follower.
Mayor:

An expert whose answer got voted for 2 times.
Problem Solver:

An expert who has answered 5 questions.

  • Contributor 6 Answers
  • Posted on Feb 15, 2013
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.
New Friend:

An expert that has 1 follower.
Mayor:

An expert whose answer got voted for 2 times.
Problem Solver:

An expert who has answered 5 questions.

Joined: Feb 15, 2013
Answers
6
Questions
0
Helped
1341
Points
7

Option: formula is
formula: =(datecell="")
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.

5 Related Answers

Anonymous

  • 5 Answers
  • Posted on Oct 04, 2007

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

Ad

Anonymous

  • 53 Answers
  • Posted on Dec 28, 2007

SOURCE: Excel Coordinates don't show up in Formula Bar

Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.

  1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
  2. On the Format menu, click Cells, and then click the Protection tab.
  3. Select the Hidden check box.
  4. Click OK.
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Cloudbooks

  • 163 Answers
  • Posted on Dec 30, 2008

SOURCE: MS Word 2003Windows everything gets selected; all is highlighted

hi,

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.

  1. On the Help menu, click Detect and Repair. To restore the program shortcuts to the Windows Start menu, make sure the Restore my shortcuts while repairing check box is selected.
  2. Click Start.
Make sure that you close all programs running.



Squirm57

Dave Herard

  • 152 Answers
  • Posted on Mar 22, 2009

SOURCE: Status bar (that shows sum of highlighted cells) has vanished

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.

Squirm57

Dave Herard

  • 152 Answers
  • Posted on May 10, 2009

SOURCE: Excel 2007: Conditional formatting

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.

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
2answers

IS THERE A FORMULA IN EXCEL THAT WILL HIGHLIGHT CELLS THAT MATCH A NUMERICAL INVENTORY LIST?
One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!
Read full answer
Sep 16, 2014 • Microsoft Excel for PC
0helpful
1answer

Excel 2007: Conditional formatting
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.
Read full answer
May 08, 2009 • Microsoft Excel for PC
1helpful
1answer

Conditional formating to highlight problems.
in Excel 2007 and if you have a cell (say C2) with the value of elapsed time (for example set = A2 which contains start time plus B2 which contains end time - or current time) - click in the cell (C2) then on the Home tab click on Styles >> Conditional formatting choose Highlight Cells Rules>>Greater Than... set your value in the dialog to your respective value and choose your highlight. This is a start - you can then add new rules.

to then apply this same conditional formatting to every cell in that column Ctrl-C to copy the cell you just formatted - then click on the column header to highlght the entire column - Right-click and choose Paste Special - then choose Formatting for what to paste.

It's slightly different in Excel 2003 so let us know what version you are using.

Cheers.
Read full answer
Feb 27, 2009 • Microsoft Office Standard for PC
0helpful
1answer

I have a year planner in excel in which first row consist of month jan,feb.... and in the second row days are there like 1, 2,3..... and on the very first column name of employees is there so my task is to...
There is always multiple solutions, but here is one...

Add a row (that can be hidden later if you want) where you have the full date (01/01/09). For this example it will be row "C." Then use Conditional Formatting with the function:

=weekday(C$2,2)>5.

See if this helps.
Read full answer
Jan 03, 2009 • Microsoft Excel for PC
0helpful
1answer

Highlight weekend in the year planner
The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.
Read full answer
Jan 03, 2009 • Microsoft Excel for PC
0helpful
1answer

To highligh weekend in the year planner
The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.
Read full answer
Jan 03, 2009 • Microsoft Excel for PC
0helpful
1answer

Need Formula
TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.
Read full answer
Dec 15, 2008 • Microsoft Windows XP Home Edition
0helpful
1answer

Conditional formatting
http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/

Go down to the section about highlighting where there's an error. That's the basics of what you want to do. Now you need the code:

This will set a value of "True" if the string is -not- found inside. So if you want to flag it for finding the word NOT, you want the conditional formatting to kick in if the value of this is FALSE.
=iserr(find("NOT",A1))

Read full answer
Dec 06, 2008 • Computers & Internet
0helpful
1answer

If statement that will change cell color in excel
conditional formatting is alright.

you just have to remove the $ signs in the cell reference when you set a condition.

then, copy-paste
Read full answer
Nov 20, 2008 • Microsoft Excel for PC
1helpful
1answer

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
Read full answer
Oct 03, 2007 • Microsoft Office Standard for PC
Not finding what you are looking for?

View Most Popular

Computers & Internet

Related Question

IS THERE A FORMULA IN EXCEL THAT WILL HIGHLIGHT CELLS THAT MATCH A NUMERICAL INVENTORY LIST?

  • Microsoft Excel for PC

76 views

Ask a Question

Usually answered in minutes!

Popular Questions

CSV file to Import correctly into Excel 2003

Microsoft Excel for PC

Indian Rupee format in Excel spreadsheet

Microsoft Excel for PC

How to select all sales entry in tally 9 and how to delete it

Microsoft Excel for PC

Excel file opens in read only mode

Microsoft Excel for PC

Using excel to solve problem by trial and error method

Microsoft EXCEL 2004 for Mac

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...