Jeff Boyes
jeff at boyes.net
Thu Apr 27 18:37:48 CDT 2006
Darren, You have to set each cell in the row to the same formula. (I have only done this one cell at a time.) The formula would be the same in every cell of the row: If Cell A20=passed, set the font to grey in THIS cell. Jeff -----Original Message----- From: Darren DICK [mailto:darrend at nimble.com.au] Sent: Wednesday, April 26, 2006 10:37 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Bit OT - Excel Q on Conditional Formatting Hi Dan If I select the whole row and set the CondFormatting to say...AirCode following... if CellValue = 'Passed' then Grey Font But there is nowhere to say if Cell A20 = Passed then Grey font from Cell A1 to a19 That's what I really want to do - apply it to the whole row based on a value in a cell Rather that have it apply to a cell based on the value in that cell Darren ------------------------------ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Thursday, 27 April 2006 12: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com