G Guest Oct 7, 2005 #1 I use conditional formatting in excel extensively but cannot figure out how to set it to indicate cells that are blank.
I use conditional formatting in excel extensively but cannot figure out how to set it to indicate cells that are blank.
G Guest Oct 7, 2005 #2 select the range of cells you want formatted this way & call up the conditional formatting dialog select "Formula is" and use =ISBLANK(relative address of active cell) and set your cell shading
select the range of cells you want formatted this way & call up the conditional formatting dialog select "Formula is" and use =ISBLANK(relative address of active cell) and set your cell shading