Coloring in Excel without using conditional f

November 25, 2009 at 00:47:48
Specs: Windows XP

I undestand that if we need to color the cells in excel based on some conditions we can use conditional formatting.
Is there any way other than conditional formatting to do the same task. Thanks!

See More: Coloring in Excel without using conditional f

Report •

November 25, 2009 at 05:51:03
Sure, use the "Fill color" or "Font color" tools to select whatever color you want the cell of font to show.

The condition used will be if you want to change the color manually or if you do not.

Otherwise the answer is no to the best of my knowledge.


Report •

November 25, 2009 at 08:06:34

You can do this with Visual Basic code.

If you have a workbook named Book1.xls with a worksheet named "Sheet1" then the following code will make the background of cell A1 grey.

Private Sub Clr()
Workbooks("Book1").Worksheets("Sheet1").Range("A1").Interior.Color = RGB(100, 100, 100)
End Sub

Add some code round it to respond to other conditions, such as the values in other cells or even the date, and this becomes a form of conditional formatting.

If you want more help on visual basic code in Excel, I suggest that you post in the Office Software forum.


Report •

Related Solutions

Ask Question