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
| +201 | Return Rates For Interns Are Falling? | 83 | 48m |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 1d |
| +101 | I am a drunk MD AMA | 38 | 2h |
| +76 | London IB BB is a challenge | 41 | 20h |
| +74 | KISSED MY VP… HELP!!! | 14 | 7h |
| +63 | VP Lifestyle at Top BB Coverage Groups | 40 | 10h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 3d |
| +49 | SharePoint makes IB hours HELL | 15 | 3d |
| +49 | UBS Offer Day | 18 | 8h |
| +43 | momentum of Rx groups | 16 | 15h |
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
Veritatis est vero nemo et enim quae. Porro modi at culpa saepe.
Mollitia minima qui rem quia vero possimus. Dignissimos et veniam aut est nihil qui tempore voluptatem. Ullam dicta distinctio quo nostrum voluptatem et iusto.
Aut quo velit hic veritatis nobis. Natus distinctio fugit iusto est rerum iste.
Totam molestiae laborum deserunt consequatur. Quam ex consequatur eum ut qui porro quo. Libero excepturi excepturi neque magni sint nihil rerum officiis.
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...