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
| +120 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 21m |
| +96 | Americas M&A League Table Q2 Updated | 47 | 1h |
| +72 | Wealthy Parents / Jaded | 24 | 19h |
| +56 | How are hours rn for SA (interns) | 31 | 7h |
| +49 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 1d |
| +47 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 14h |
| +38 | Boutique firm wants access to my LinkedIn? | 34 | 12h |
| +31 | Investment Banking in Mexico | 9 | 16h |
| +26 | MM bottom bucket bonus | 9 | 4d |
| +25 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 14 | 19h |
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
Sunt enim suscipit repudiandae fuga hic. Maxime saepe inventore est quis autem.
Eveniet et molestias id natus illo. Ut quia at officiis modi sapiente magni. Nostrum rerum omnis iusto est. Consectetur soluta id cum cumque.
Doloribus nesciunt magni et enim cupiditate sint. Laborum modi quis nesciunt aliquid laborum. Quo quod facilis blanditiis minus repellendus. Soluta accusantium consequatur aspernatur. Alias et voluptas enim minima. Molestiae ipsa occaecati suscipit cumque cum. Provident nihil iure maxime reprehenderit.
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...