What excel formula do i need to say that if a

February 15, 2011 at 16:02:05
Specs: Windows XP
I have a series of 3 cells with data. Further down page I want to put a line using coditional formating.

if cell 2 has data i need the cell where the line is to be to have for example a 1 appear. Then i can con form the cell to have a line.

I dont know the formula to recognise text in a cell as apposed to being to the cell being blank


See More: What excel formula do i need to say that if a

Report •


#1
February 16, 2011 at 08:51:35
I believe a blank cell is recognized as "". So IF cell is not "", then it is something. Maybe post your data or examples to get more help.

Report •

#2
February 16, 2011 at 08:56:06
=IF(A1<>"", "I am not blank", "I am blank")

or

=IF(A1="", "I am blank", "I am not blank")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question