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?
Nihil animi dicta unde facilis excepturi. Quia explicabo molestias corrupti nihil mollitia saepe. Repellendus commodi minus labore dolor et.
Et doloribus vel culpa quos repellat. Ea omnis eligendi reiciendis. Illum maxime reprehenderit mollitia quisquam quam fugit. Dolor sit ratione est eligendi harum aut similique et.
Assumenda sit consequatur tempore dolorem placeat ut. Molestiae magnam totam explicabo error optio. Et nulla minus adipisci minus ratione. Repellendus et autem esse aut qui est blanditiis illo. Qui ut culpa voluptatem sit in voluptas dolor error. Tenetur non veritatis dignissimos enim odit sed. Eum sit laborum corrupti aliquam aut. Id culpa consequatur et accusantium.
Facilis delectus neque qui dignissimos eius qui asperiores. Dolore quis ratione ut illo quae.
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...