Conditional Formatting - Dates
I need to set conditional formatting to change the color on cells which are
NOT either 06 or 21 in the date format. Column is 10/06/09 10/21/09 11/06/09 11/20/09 12/04/09 12/21/09 01/06/10 01/21/10 02/05/10 02/19/10 03/05/10 03/19/10 04/06/10 04/21/10 05/06/10 05/21/10 06/04/10 06/21/10 |
Conditional Formatting - Dates
Hi,
Select this column of dates then Format|Conditional format - formula is - enter the formula =AND(DAY(A1)<6,DAY(A1)<21) Pick a colour - OK Change A1 in the formula to the addtess of the topmost selected cell. Mike "nbslarson" wrote: I need to set conditional formatting to change the color on cells which are NOT either 06 or 21 in the date format. Column is 10/06/09 10/21/09 11/06/09 11/20/09 12/04/09 12/21/09 01/06/10 01/21/10 02/05/10 02/19/10 03/05/10 03/19/10 04/06/10 04/21/10 05/06/10 05/21/10 06/04/10 06/21/10 |
Conditional Formatting - Dates
Thank you, thank you, thank you! You are wonderful!!!
"Mike H" wrote: Hi, Select this column of dates then Format|Conditional format - formula is - enter the formula =AND(DAY(A1)<6,DAY(A1)<21) Pick a colour - OK Change A1 in the formula to the addtess of the topmost selected cell. Mike "nbslarson" wrote: I need to set conditional formatting to change the color on cells which are NOT either 06 or 21 in the date format. Column is 10/06/09 10/21/09 11/06/09 11/20/09 12/04/09 12/21/09 01/06/10 01/21/10 02/05/10 02/19/10 03/05/10 03/19/10 04/06/10 04/21/10 05/06/10 05/21/10 06/04/10 06/21/10 |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com