| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add text in a cell based on colour of text in another cell
Hi
I have recorded a macro to add "For Sale" into cell J3 if the text in column A3 is red. I added an IF THEN and it works but how do I get it to repeat in all cells as in cell J4 needs to be set to "For Sale" if the text in cell A4 is red all the way down to J1311. Sub Macro4() Range("A3").Select If Selection.Font.ColorIndex = 3 Then Range("J3").Select ActiveCell.FormulaR1C1 = "For Sale" End If End Sub Thanks in advance Ian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change cell text colour based on value in other cell | Excel Worksheet Functions | |||
| how to colour a cell green if another cell is filled with text | Excel Discussion (Misc queries) | |||
| Cell Colour based on text in Range of cells | Excel Programming | |||
| Cell Colour based on text in Range of cells | Excel Programming | |||
| Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
Threaded Mode
