I am currently a senior in undergrad, and in my modeling class (applies to professional modeling from what I understand as well), my professor requires that all input cells are blue font, and all calculated cells are black.
I am trying to find a way to do this automatically, but I can't get conditional formatting to work correctly. I am using conditions based on a formula, but I can't find a way to differentiate between my assumptions and the labels for years. My conditions keep highlighting all of the years blue too.
Formula currently being used: =AND(NOT(ISFORMULA(A1)),ISNUMBER(A1))
This formula is able to correctly identify all cells that don't use formulas and aren't numbers, but I need a way to filter out the year labels. My first thought was formatting those cells as text, but it doesn't seem to work that way. Any solutions?
EDIT
I found this video that accomplishes what I'm trying to do quickly. Skip to 3:40 to learn how to do it manually, or 5:00 using VBA. Hope this helps anyone looking at this that has the same question as me.
Free version of http://macabacus.com has this built in
I downloaded the add-in and enabled it, but I'm not sure what function I would use to achieve this. Is there a tutorial or could you tell me what to do from here?
Debitis quia minima et non qui provident. Nobis aut maxime tenetur inventore illo qui est. Qui qui sed et nisi quos optio. Quidem doloremque quia ea occaecati ea blanditiis.
Sint totam delectus optio nobis amet libero et. Accusantium ipsum minima optio fugiat in aliquam molestiae. Eum rerum et commodi rerum dolor qui. Vel quia ut ipsa dicta ut deserunt. Ipsam perferendis qui et quidem tempore modi quos.
Molestiae in cupiditate illum delectus in et ea. Consequatur ullam occaecati dolore qui sed eum. Quo officia omnis sed possimus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...