Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to colour highlight empty cell
I have a worksheet with many cells that need to be address individually,
either numerically or otherwise. How do I conditionally highlight cells that have not been addressed? A cell that contains the numeric value 0 (zero) has been address, whereas an empty cell has not. It is a pain visually scanning. It is also an option to highlight cells that have been address either numerically (including 0) or otherwise. Thanks Guys and Gals if you could help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to colour highlight empty cell
highlight all the cells that need to have info in them. Make note of which
cell is active (for example, I'll use A2). Format - Conditional Format, formula is: =ISBLANK(A2) Set desired formatting. Ok out. Similarly, you could use the following two conditions: =ISNUMBER(A2) =ISTEXT(A2) To check whether the cell contains a number or just regular text. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Owen P" wrote: I have a worksheet with many cells that need to be address individually, either numerically or otherwise. How do I conditionally highlight cells that have not been addressed? A cell that contains the numeric value 0 (zero) has been address, whereas an empty cell has not. It is a pain visually scanning. It is also an option to highlight cells that have been address either numerically (including 0) or otherwise. Thanks Guys and Gals if you could help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to colour highlight empty cell
You have a choice of two CF conditions:
=ISBLANK(A1) if you want to exclude cells with the empty string "" =A1="" will highlight both totally empty cells and those with the empty string "" -- David Biddulph "Owen P" <Owen wrote in message ... I have a worksheet with many cells that need to be address individually, either numerically or otherwise. How do I conditionally highlight cells that have not been addressed? A cell that contains the numeric value 0 (zero) has been address, whereas an empty cell has not. It is a pain visually scanning. It is also an option to highlight cells that have been address either numerically (including 0) or otherwise. Thanks Guys and Gals if you could help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making the highlight or cell selection colour darker in Excel 2007 | Setting up and Configuration of Excel | |||
Can I change the default cell selection highlight colour | Excel Discussion (Misc queries) | |||
Cell selection highlight colour | Excel Worksheet Functions | |||
highlight cell with colour if date overdue | New Users to Excel | |||
Excel - highlight colour of cell not showing except on preview | Excel Discussion (Misc queries) |