Formating One Cell based on If Another is Empty

J

jdcollins21

I've got a range of data (5 columns total, changing number of rows
which I want to udate.
When column 3 is empty and column 4 is not, I want it to enter the wor
"NEW" in column 1.

Any help would be greatly appreciated
 
J

JerryG

If row 1 containes your column headers, try this formula
in cell A2 (I assume your column 1) and copy it down thru
all the rows you wish to use it. Let me know if this is
what you were looking for . . .

=IF(ISBLANK(C2),IF(ISBLANK(D2),"","NEW"),"")

Jerry
 
Top