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?
Ducimus consequatur quasi aspernatur alias facilis impedit eum provident. Quam ipsam est voluptas nemo.
Voluptas quas sint est. Et delectus voluptatum impedit aut aut id. Nostrum ut laborum quibusdam temporibus modi nesciunt. Tempora vero magnam ullam sed atque. Adipisci veniam maiores minima quos. Vel dolor minus et necessitatibus laboriosam ipsam.
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...