Search : in
By :

Pls help - Excel - Highlight cell if no data

Last answer on Aug 28, 2009 9:28:16 pm BST ems, on Jun 10, 2009 5:27:22 pm BST 
 Report this message to moderators

Hello,
Please could somebody help me with a problem. I have a spreadheet and i would like make some cells in a row go yellow if they have no data in them. the data will either be text or a date. This is to highlight if ALL information on a spreadsheet row has NOT been entered or has been left out (the row info will be entered over a period of time)

If this cannot be done do you know how to just make one cell turn yellow if there is no date entered?


Thank you for any help

ems

Configuration: Windows XP Internet Explorer 7.0
I am using Office Excel 2003 on MS office Proffesional 2003 on XP system

Best answers for « pls help Excel Highlight cell if no data » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

Sonu, on Jun 10, 2009 6:46:26 pm BST
  • +4

Try using conditional formatting

   
Reply to Sonu

2

Tom, on Aug 21, 2009 3:49:19 pm BST

I have tried using conditional formatting but i can't figure this out.

I have daily logs that track issues/problems with our equipment. I have a cell that we enter in the time/data the issue was fixed. What I want to do is have the rows without any information in the time/date cell highlight a specific color.

If this can be done in conditional formatting please tell me how.

Thanks,
Tom

   
Reply to Tom

3

 TR, on Aug 28, 2009 9:28:16 pm BST
  • +2

Assume the cell you want conditional formatting on is cell D9.
select cell D9.
Select Format > Conditional Formatting... menu option
In the Conditional Formatting dialog, change the 1st drop down from "Cell Value Is" to "Formula Is"
In the formula enter "=IF(LEN(TRIM(D9)) = 0, TRUE, FALSE)" without the quotes.
Then select the Format button and select the Patterns Tab. Select the color you want for the background of the cell.

If you want to highlight the whole row based on the value of this cell, change D9 to $D9. Then copy cell D9, select the row, right click and "Paste Special...". Select Formats checkbox and click Ok.

To apply this to all of the other Rows, select row 9 and copy it. Select all of the rows and "Paste Special...". Select Formats checkbox and click Ok.

   
Reply to TR
Ask your question Reply
They need your help