[AccessD] Bit OT - Excel Q on Conditional Formatting

PS these routines change the font color (not the cell background itself) so
there has to be something in the cells to the right to be able to see the
change. :-)
Jim Hale 

-----Original Message-----
From: Hale, Jim [mailto:Jim.Hale at fleetpride.com]
Sent: Thursday, April 27, 2006 10:23 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Bit OT - Excel Q on Conditional Formatting


Here is a different method to try. Place these sub routines as code behind
the sheet in question. Type the word "Passed" in a cell. (BTW the routines
are case sensitive) It doesn't matter which cell as long as there are at
least 5 more columns to the right. The first sub routine changes that cell
and the cells in the first five columns to the right to red when you exit
the cell. The A1:F1 reference is relative to the activecell. If the word
Passed is already in the cell the second sub will change the cell and the
cells in the first five columns to the right to red when you click on the
cell.    HTH

Jim Hale

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = "Passed" Then
    Target.Range("A1:F1").Font.ColorIndex = 3
    End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo PROC_ERR
If ActiveCell.Value = "Passed" Then
    ActiveCell.Range("A1:F1").Font.ColorIndex = 3
              
End If
PROC_ERR:
End Sub

-----Original Message-----
From: Dan Waters [mailto:dwaters at usinternet.com]
Sent: Wednesday, April 26, 2006 9:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Bit OT - Excel Q on Conditional Formatting


Darren,

Would it work to apply CF to each cell in the row?  The test for each would
be to look at the same cell.  I haven't done much CF in Excel - maybe
absolute references in the CF expression would allow you to copy once and
paste into the CF expression field for the other cells in the row.

Dan 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Wednesday, April 26, 2006 9:39 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Bit OT - Excel Q on Conditional Formatting


Hi All
We have an excel spread sheet that our 'testers' use to test for bugs in
software So there are various column headers eg What Tested, TestedBy, Test1
Results etc but the final column is the 
one that has final say on what is done.
If it says 'closed' or 'passed' I want the whole row to be grey font, italic
font etc to visually indicate 'it is finished' with
 
In the past I have applied cond formatting to whole columns that apply cond
formatting to individual cells depending on their value but this is the
other way about. IE a cell changing the formatting for the whole row
 
Many thanks in advance
 
Darren
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.