Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Blank cell revisited
I am re-posting this one 'cause I couln't make the procedure provide for
it's solution work. I In a worksheet I am createing there is colum titled "Date Closed",-- the whole column is set to a light blue background color, the rest of the sheet is white with gridlines. At time of closure the date is entered. I would like to have any cell in that column that is blank -- no closing day yet entered, I to have a red background and when I enter a closure date, I want it to change to be the original color I set for the column. The column I am using is J and Dave gave me this formula: =J1="" to use. I went to Format/conditional formatting. I selected formula from the drop-down and put that formula in, adusted the format to red background color and when I hit enter, although there are plenty of blank cells in the J column, none of them turn red. Why not? Doable? Thanks Ross |
#2
|
|||
|
|||
Are you positive those cells are blank.
Select one of those blank cells and hit the delete key. Did it change colors? Another test... Say J23 looks blank, but it doesn't change colors. Put this in another cell: =isblank(j23) and this in another cell =len(j23) What do you get back from both? The answers will help with the next response. Ross wrote: I am re-posting this one 'cause I couln't make the procedure provide for it's solution work. I In a worksheet I am createing there is colum titled "Date Closed",-- the whole column is set to a light blue background color, the rest of the sheet is white with gridlines. At time of closure the date is entered. I would like to have any cell in that column that is blank -- no closing day yet entered, I to have a red background and when I enter a closure date, I want it to change to be the original color I set for the column. The column I am using is J and Dave gave me this formula: =J1="" to use. I went to Format/conditional formatting. I selected formula from the drop-down and put that formula in, adusted the format to red background color and when I hit enter, although there are plenty of blank cells in the J column, none of them turn red. Why not? Doable? Thanks Ross -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Go to first blank cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |