Jim Hewson
JHewson at karta.com
Fri Apr 28 08:39:15 CDT 2006
I've set Conditional Formatting for an entire range. The key is to choose a cell/row where you can set the parameters. For example: to apply CF to range B2:H20 Open a blank Worksheet Highlight B2 through H20 Start with B2 and go towards H20 Open CF Change "Cell Value Is" to "Formula Is" In the formula type in =$A2=1 Then format by choosing a color for the cell Click Add Follow the above and choose a different color Do it again for a third row color. Close CF. Test it. By putting 1, 2, or 3 in column A the rows will change. Any formula will work as long as the results are true/false. HTH Jim jhewson at karta.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Boyes Sent: Thursday, April 27, 2006 6:38 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Bit OT - Excel Q on Conditional Formatting 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com