is not blank

  1. J

    Formula to find column value with ticked/filled cells for Google Sheets

    I have a question about what formula I should use for the following: I have a spreadsheet (similar to below). Across the columns are values such as A, B, C etc. Down the rows are item numbers. I have one table which has these items down the rows and ticks next to the relevant column value. E.g...
  2. S

    Conditional Formatting While Using Not Is Blank Function

    I want to use conditional formatting to color a cell if it is greater than 0 while the formula in the cell is this - =IF(NOT(ISBLANK(G6)),F6-G6," "). The problem is when I drag the conditional formatting down it turns the whole column a color even when a value is not yet showing up in the cell...
  3. O

    If a cell=((ISBLANK(REF)), then (Another NOT(ISBLANK(cell)))?

    Hi, I'm trying to set a formula so that if a cell is blank and the cell above is not, then the destination cell takes the value of the not blank cell: (in this example C2 is the value having cell and C3 is the blank cell) Something like =if((ISBLANK(C3)), AND(NOT(ISBLANK(C2))),THEN C2) Your...
  4. S

    would like to delete rows with blank cell. but excel thinks it is not blank is blank but excel thinks it is not

    Enigma: there are cells in my workbook that are "blank" even when you hover the mouse over the cell the formula bar is blank. However when I print the page I get 8 blank pages. When I go to print preview the cells are blank but excel thinks that it is used so it is not blank. when I use formula...
    • shammie4
    • Thread
    • blank cells delete blank is not blank isemptyempty
    • Replies: 5
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top