font color

I have a workbook with two spreadsheets. One has a series of cells (say, A7:G7) that return a word ("Red", "Yellow", "Green", "Blue") based on a lookup table in the other worksheet with an array defined spanning (J2:L1006) that contains the words. The table array may be irrelevant. A dropdown...

I have a workbook with two spreadsheets. One has a series of cells (say, A7:G7) that return a word ("Red", "Yellow", "Green", "Blue") based on a lookup table in the other worksheet with an array defined spanning (J2:L1006) that contains the words. The table array may be irrelevant. A dropdown...

Hello, I have a spreadsheet which uses 2 different colors to designate how something is mailed. If it is mailed one way, there is a corresponding date in one column and if it is mailed the 2nd way, another date in another column. For example - code 1110 is in cell C1, date1 is in cell A1 and...

I don't want the text to show in a visible cell B1 when a group of adjoining columns is collapsed so I want to format the font in cell b1 white when the group is collapsed (level 1) and automatic = black when it is expanded (level 2). How can I? Here are my first two attempts to piece this...

I am using a macro and worksheet, found on the form and changing it to fit my needs, that takes a list of dates and creates a calender. There are multiple events on a single date (or Cell) I want to format the text of individual events to be color coded based on a value. Here is the code I am...

A friend wanted help to write a macro to change the text colour (to turn blue text to black and red text to blue) I thought I could help and so made this: Sub changecol() For Each Cell In Selection If Cell.Font.ColorIndex = 37 Then Cell.Font.ColorIndex = 1 End If Next For...