Does anyone know how to have Excel automatically format cells depending on the contents being values, formulas, off-worksheet references (i.e. blue / black / green) without using a paid plug-in? I am trying to get this to work with conditional formatting but am having no luck. Thanks.
Trending Content - Investment Banking Forum
| +439 | Don’t work at UBS - UBS Sucks | 40 | 10h |
| +327 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 4d |
| +186 | Should My Intern Get a Return Offer? | 53 | 12h |
| +64 | When to Leave Office as Intern | 8 | 6d |
| +56 | F*ck it I'm Going to Med School | 19 | 1d |
| +40 | Living in greenwich as an analyst? | 8 | 9h |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 5d |
| +39 | Getting Laid in IB? | 20 | 4h |
| +32 | STEM student lost in London IB recruiting | 18 | 15h |
| +27 | NYC Associate Budget | 9 | 7h |
Career Resources
bump
F5 go to special.
Test this in a separate workbook first. Not sure how you want to select the greens. In case you want to choose different colors you can switch the code to .color = rgb(x, y, z)
Here's my fav link to color codes. http://dmcritchie.mvps.org/excel/colors.htm
Sub FontColor() ' ' For each worksheet in active workbook ' Select cells containing formulas, then constants ' Color these cells Black and Blue, respectively '
Dim ws As Worksheet Application.ScreenUpdating = False On Error Resume Next For Each ws In ActiveWorkbook.Worksheets ws.Activate Cells.SpecialCells(xlCellTypeFormulas, 23).Select With Selection.Font .ColorIndex = 1 End With Cells.SpecialCells(xlCellTypeConstants, 23).Select With Selection.Font .ColorIndex = 5 End With Next ws Application.ScreenUpdating = TrueEnd Sub
Laudantium voluptatibus aut quisquam sed inventore qui. Culpa sint dolorum commodi aspernatur tenetur vel et. Ut modi aut quia sunt sit non incidunt. Autem sit iusto enim id iste.
Autem sit corrupti quia et. Consequuntur voluptatem totam velit architecto aliquam quod voluptatem. Quaerat nesciunt illum similique qui id.
Natus maiores libero consectetur. Cumque officiis neque dolores nihil velit explicabo quidem.
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...