Forum Discussion
Comparing data in columns on 2 separate worksheets
Good afternoon, I am currently running Windows 10 and I am using Microsoft® Excel® for Microsoft 365 MSO (Version 2110 Build 16.0.14527.20234) 32-bit. I am looking for a daily report that l...
Jeri_info4u The custom formatting is entered in the following steps.
Select any cell in the variance column, right-click,
select Value Field Settings...
Press the Number Format button (bottom left)
Choose custom and enter the required format in the Type-field. Press OK.
Don't really understand why you get a "null value" error message. Can you otherwise upload your file? Then I can have a look.
I am so sorry I am just now getting back to you but I have been super busy and had to work a lot of overtime during the holiday. I am going to upload what my file looks like. I'm obviously missing a step somewhere because I am not getting a variance column to produce. Allow me a moment to upload that data.