| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Blank cells
I need to format a cell so that if it stays blank, the cell is red.
|
|
#2
|
|||
|
|||
|
One way:
Format/Conditional Formatting... CF1: Formula is =ISBLANK(A1) Format1: Pattern/Red In article , "denisesnews" wrote: I need to format a cell so that if it stays blank, the cell is red. |
|
#3
|
|||
|
|||
|
What do you mean "so it stays blank". If you want it to APPEAR blank, make
the font match the fill (red). ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "denisesnews" wrote in message ... I need to format a cell so that if it stays blank, the cell is red. |
|
#4
|
|||
|
|||
|
Use: IF(ISBLANK,(INPUT THE ADDRESS OF CELL),"",PUT THE DESIRED RESULT HERE.)
"denisesnews" wrote: I need to format a cell so that if it stays blank, the cell is red. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skip blank cells in diagrams | Charts and Charting in Excel | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| What function can make cells shift up when they are blank? | Excel Worksheet Functions | |||
| how do you ignore blank cells | Excel Discussion (Misc queries) | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
Linear Mode
