Track New Added Row In Sheet 2

[DDTiff]

Hello,

Can someone please help me with this? Thank you for your help in advance.

I have a worksheet, and I would like the row color to change from white to green when a user enter information into a blank row. I have tried to enter this formula into Conditional Format Formula: "=NOT(ISBLANK(ROWS()))" but it would not let me do it. Do I have to write code to make this work?

Thank you once more time for your help.

DDTiff

 

[Bowers74]

Try something like this in your Conditional Formatting:

=NOT(COUNTA(1:1)=0) for row 1

Hope this helps!




Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[DDTiff]

Thanks Mike for your response, but when I added the formula into the Conditional Format, only the cell "A1" changed color.

What should I do to change so it reponds to the whole row?

Thank for your help.

 

[DrBowes]

select the entire sheet first

 

[DDTiff]

Mike, it works like a charm. Thank you very much for your help and time.

 

[DDTiff]

Hello Again,

I have another question that I have been trying to figure out for two days.

If my worksheet already has data in it, and I want to change the font color of any row that used to be empty and now has new added information.

For example, the information that I entered previously will be black font color, and anything that I added later on will have green font color.

Thank you in advance for your help.

 

[Bowers74]

Have you though about using the "Highlight Changes" feature.

Tools->Track Changes->Highlight Changes ...



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[DDTiff]

Yes, I did. I thought there is another way to track using the conditional formats. Maybe tracking changes is the only way. Please let me know if you have another way come to mind. I appreciate your time and assistance.

DDTiff

 

[Bowers74]

If my worksheet already has data in it, and I want to change the font color of any row that used to be empty and now has new added information.

Isn't that what we just covered with the first solution, or do you mean any CELL that was previously empty?



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[DDTiff]

Mike,

My goal is that I want to be able to tell what information is old and what has just been added (information configuration control).

The first solution only let me turn on and off the color of the row when the row is either empty or not. It doesn't tell me whether the information is new or old.

Thank you,

DDTiff

 

[AlexmacG]

As another respondant implied, probably best using track changes for config control purposes as it can:
highlight on screen ,
allow selective acceptance and
also produce a history of changes listed on a sheet for full traceability, including the user that modified.