Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i know if a cell should have data but doesn't?
I'm trying to find a way to get a visual alert if a cell should have a number
in it, but doesn't. i.e. one column is for how many files were sent, the next column is for how many we received back. If we don't enter anything in the "received back" column, I want to be able to see that at a glance without having to scroll through a long sheet and possibly missing an empty column. Thanks so much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i know if a cell should have data but doesn't?
From your description you could consider using conditional formatting to
highlight areas where you do not have corresponding receipts. Additionally you may want to add a control total which counts the number of sent files vs received files. -- HTH... Jim Thomlinson "exceluser" wrote: I'm trying to find a way to get a visual alert if a cell should have a number in it, but doesn't. i.e. one column is for how many files were sent, the next column is for how many we received back. If we don't enter anything in the "received back" column, I want to be able to see that at a glance without having to scroll through a long sheet and possibly missing an empty column. Thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting numerical data in one cell to word data in another cell | Excel Worksheet Functions | |||
how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
moving data to a cell, not pulling data to the cell | Excel Worksheet Functions | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) |