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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Need Help with a VBA subroutine 0
List all tables, including document structure 0
Hide columns based on row values 2
Rearranging Data 0
Arriving at totals 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Count Non-Empty Cells In Each Row 0

Top