Excel Gurus:
I have this file that I share with 40 people. The data dump has about 15 columns. The 15 columns come from a standard report. The information is considered static but sometimes we do manual adjustments by adding additional rows to the data dump. All fields are populated but one which is system generated. Is there a way to format that? Let’s say highlight in yellow if not all fields are populated. That way it jumps at me without having to do it manually.
Thanks,
NN
I have this file that I share with 40 people. The data dump has about 15 columns. The 15 columns come from a standard report. The information is considered static but sometimes we do manual adjustments by adding additional rows to the data dump. All fields are populated but one which is system generated. Is there a way to format that? Let’s say highlight in yellow if not all fields are populated. That way it jumps at me without having to do it manually.
Thanks,
NN