[AccessD] Bit OT - Excel Q on Conditional Formatting

Dan Waters dwaters at usinternet.com
Wed Apr 26 21:49:42 CDT 2006


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




More information about the AccessD mailing list