|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 22nd, 2006, 03:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another Conditional Formatting Question
I have 898 rows of information spread across 13 columns. Column "G" has
dates (898 *different* dates...). What I want to do is set a conditional formula to change the font, of the whole row, only if the date is older than "today". I must be able to select all of the cells and set the formatting at once, but I can't seem to get it correct. Thanks. 
|
|
#2
July 22nd, 2006, 04:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Another Conditional Formatting Question
Hi, I would suggest only selecting the 13 columns not the whole workbook. Then in Conditional Formatting enter. =IF($G3TODAY(),TRUE,FALSE) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563981
|
|
#3
July 22nd, 2006, 05:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Another Conditional Formatting Question
Thanks Noob,
However that formula also highlights rows that are "newer" than today as well. Thinking back to my previous post, I may not have explained that I only want rows with dates older than "today" to be highlighted. "VBA Noob" wrote: Hi, I would suggest only selecting the 13 columns not the whole workbook. Then in Conditional Formatting enter. =IF($G3TODAY(),TRUE,FALSE) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563981
|
|
#4
July 22nd, 2006, 07:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Another Conditional Formatting Question
Select Rows G1:G898
FormatCFFormula is: =$G1TODAY() Gord Dibben MS Excel MVP On Sat, 22 Jul 2006 07:49:02 -0700, 1320_Life wrote: I have 898 rows of information spread across 13 columns. Column "G" has dates (898 *different* dates...). What I want to do is set a conditional formula to change the font, of the whole row, only if the date is older than "today". I must be able to select all of the cells and set the formatting at once, but I can't seem to get it correct. Thanks.
|
|
#5
July 22nd, 2006, 10:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Another Conditional Formatting Question
That's it! Thanks Gord!
"Gord Dibben" wrote: Select Rows G1:G898 FormatCFFormula is: =$G1TODAY() Gord Dibben MS Excel MVP On Sat, 22 Jul 2006 07:49:02 -0700, 1320_Life wrote: I have 898 rows of information spread across 13 columns. Column "G" has dates (898 *different* dates...). What I want to do is set a conditional formula to change the font, of the whole row, only if the date is older than "today". I must be able to select all of the cells and set the formatting at once, but I can't seem to get it correct. Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting Question | mwevans1234 | Worksheet Functions | 2 | May 24th, 2006 10:37 PM |
| Conditional formatting, simple question... | Kelly | Worksheet Functions | 2 | March 1st, 2006 07:31 PM |
| Another Conditional Formatting Question | JamesJ | Using Forms | 0 | November 12th, 2005 02:16 AM |
| Excel Macro Question about Conditional Formatting | David Britton via OfficeKB.com | New Users | 3 | February 10th, 2005 02:23 PM |
| Additional Conditional Formatting Question | Sinfante | General Discussion | 13 | August 2nd, 2004 04:20 AM |
Linear Mode
