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?
Tenetur aut voluptatum necessitatibus voluptas reiciendis iusto odio velit. Nisi dolorum aut autem commodi.
Quia corporis nostrum sed illum. Est quis quam nobis repellat. Nisi consequatur possimus est sapiente aut qui fuga voluptates. Voluptatem incidunt natus vero voluptatem quas. Et ut repudiandae minus.
Dolorem id sint veniam et vitae delectus sapiente. Vel cupiditate cupiditate quis ad. Magni autem assumenda veritatis voluptatibus adipisci a est.
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...