Formating One Cell based on If Another is Empty

  • Thread starter Thread starter jdcollins21
  • Start date Start date
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
 
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
 
Back
Top