Color Question in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 13 Apr 2004 15:12 GMT

Say I have a spreadsheet with several columns and rows of data. Say
column G is a column that I enter a date when a "case" is closed. Can I
format the cell so that when a date is entered into column G12, for
example, the entire contents of row 12 turns another color, such as
red. What I'm looking for is a quick visual way to look at the
spreadsheet and tell which cases are closed vs open.

Thanks,

John

Reply to this Message

Frank Kabel - 13 Apr 2004 15:26 GMT

Hi
have a look at 'Format - Conditional Formating'. e.g. in your case
celect cells A12:G12, goto this dialog and enter the formula
=$G12<>""
and choose a format

also have a look at
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Say I have a spreadsheet with several columns and rows of data. Say
> column G is a column that I enter a date when a "case" is closed.
[quoted text clipped - 6 lines]
>
> John

Reply to this Message

John - 13 Apr 2004 15:39 GMT

Frank... I'd buy you a beer if I could. Thanks for your help once again!

John

> Hi
> have a look at 'Format - Conditional Formating'. e.g. in your case
[quoted text clipped - 21 lines]
> >
> > John

Reply to this Message

Don Guillett - 13 Apr 2004 15:45 GMT

Right click on sheet tab>view code>insert this.
Now if you enter a date in column g below row 2 you get purple.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 7 Or Target.Row < 3 Then Exit Sub
If IsDate(Target) Then _
Target.EntireRow.Interior.ColorIndex = 7
End Sub

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> Say I have a spreadsheet with several columns and rows of data. Say
> column G is a column that I enter a date when a "case" is closed. Can I
[quoted text clipped - 6 lines]
>
> John

Reply to this Message