Ramsey Posted March 4, 2014 Report Share Posted March 4, 2014 Im trying to simulate conditional formatting in excel. I need the sum total cell to turn green if it equals the first cell. Example: first cell is the "stated" total, then next few cells add up to the "actual" total. I need it to show me quickly when they dont match. Quote Link to comment Share on other sites More sharing options...
Turbs3000 Posted March 4, 2014 Report Share Posted March 4, 2014 Can you use this? https://support.google.com/drive/answer/78413?hl=en OR, can you just have another column that lists x-y, that way anything that's not 0 sticks out? Quote Link to comment Share on other sites More sharing options...
Ramsey Posted March 4, 2014 Author Report Share Posted March 4, 2014 Its for a months worth of deposits. So march 1st will have a unique number total like 8,765.43 and the few deposits from cash/v/mc/d should add up to equal the total. Quote Link to comment Share on other sites More sharing options...
Ramsey Posted March 4, 2014 Author Report Share Posted March 4, 2014 Can you use this? https://support.google.com/drive/answer/78413?hl=en OR, can you just have another column that lists x-y, that way anything that's not 0 sticks out? Mine doesnt show "custom format" Quote Link to comment Share on other sites More sharing options...
greg1647545532 Posted March 4, 2014 Report Share Posted March 4, 2014 Mine doesnt show "custom format" Mine didn't either. I had to follow the directions on that page in order to "Try the New Google Sheets", and it still didn't show up. I created a new document and it was there, so I'm guessing Google isn't automatically converting existing sheets to the new format. You may be able to copy/paste everything into a new sheet (after turning on the new stuff) and get it working that way. 1 Quote Link to comment Share on other sites More sharing options...
Ramsey Posted March 4, 2014 Author Report Share Posted March 4, 2014 Mine didn't either. I had to follow the directions on that page in order to "Try the New Google Sheets", and it still didn't show up. I created a new document and it was there, so I'm guessing Google isn't automatically converting existing sheets to the new format. You may be able to copy/paste everything into a new sheet (after turning on the new stuff) and get it working that way. PLUS REP!!!!!!!! fixed it! I down loaded the new sheets and imported the working excel file, and everything works! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.