I created a table by importing a cvs with 80 rows, 15 columns. All rows have Columns 1 - 5 pre filled with data.remaining columns / rows are blank/null/"" whatever. Column 6 is a string for a persons name and set to E 'Cannot be empty'. I want to change row/cell color when the cell in Column 6 is edited, should have a name added to it. I have tried every combination of operators and " " , null etc... but have not figured it out.

So how do I test for an empty, null cell with conditional formatting options to change cell / row color when 'not null'?

I could fill it with a known value to test against but if that value was deleted and cell is empty I am back to testing for a null / empty cell.

If a Predefined value(s) is set in Editing tab would cell be updated to that value if a value was enter by user the deleted by user. Example predefined value 'Open' User enters a name and submits edit, edits again and deletes name will cell value be 'Open' (Predefined value(s)?

Thanks for the help with such a simple issue.

Ray

I feel foolish now, I tried everything but leaving it blank, exactly what I was testing for.

Thank you.