|
| 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
May 9th, 2006, 12:39 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Hiding or Formatting non matching cells
Hello Again
in column A i have 31 cells representing a 31 day month using tha =a2+1 for all 31 days, but some months have less, so the eg: below is a pain to look at. Is there a way to make the non matching dates, to be not visible when the month changes. 27-feb 28-feb 1-mar Thanks again Allan 
|
|
#2
May 9th, 2006, 02:31 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Hiding or Formatting non matching cells
Hi!
One way: Assume the dates are in the range A1:A31. Since you only need to be concerned with the last 3 cells representing the 29th, 30th and 31st of the month: Select the range A29:A31 Goto FormatConditional Formatting Formula Is: =MONTH(A29)MONTH(A$1) Click the Format button Set the font color to be the same as background color OK out Biff "A.R.J Allan Jefferys" wrote in message ... Hello Again in column A i have 31 cells representing a 31 day month using tha =a2+1 for all 31 days, but some months have less, so the eg: below is a pain to look at. Is there a way to make the non matching dates, to be not visible when the month changes. 27-feb 28-feb 1-mar Thanks again Allan
|
|
#3
May 10th, 2006, 01:12 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Hiding or Formatting non matching cells
thanks Biff
It worked like a charm. Regards Allan "Biff" wrote: Hi! One way: Assume the dates are in the range A1:A31. Since you only need to be concerned with the last 3 cells representing the 29th, 30th and 31st of the month: Select the range A29:A31 Goto FormatConditional Formatting Formula Is: =MONTH(A29)MONTH(A$1) Click the Format button Set the font color to be the same as background color OK out Biff "A.R.J Allan Jefferys" wrote in message ... Hello Again in column A i have 31 cells representing a 31 day month using tha =a2+1 for all 31 days, but some months have less, so the eg: below is a pain to look at. Is there a way to make the non matching dates, to be not visible when the month changes. 27-feb 28-feb 1-mar Thanks again Allan
|
|
#4
May 10th, 2006, 06:30 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Hiding or Formatting non matching cells
You're welcome. Thanks for the feedback!
Biff "A.R.J Allan Jefferys" wrote in message ... thanks Biff It worked like a charm. Regards Allan "Biff" wrote: Hi! One way: Assume the dates are in the range A1:A31. Since you only need to be concerned with the last 3 cells representing the 29th, 30th and 31st of the month: Select the range A29:A31 Goto FormatConditional Formatting Formula Is: =MONTH(A29)MONTH(A$1) Click the Format button Set the font color to be the same as background color OK out Biff "A.R.J Allan Jefferys" wrote in message ... Hello Again in column A i have 31 cells representing a 31 day month using tha =a2+1 for all 31 days, but some months have less, so the eg: below is a pain to look at. Is there a way to make the non matching dates, to be not visible when the month changes. 27-feb 28-feb 1-mar Thanks again Allan
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Move merged cells with conditional formatting? | SpikeUK | Worksheet Functions | 11 | December 8th, 2005 05:04 PM |
| checking that cells have a value before the workbook will close | kcdonaldson | Worksheet Functions | 8 | December 5th, 2005 04:57 PM |
| conditional formatting on specific text in cells | kwkhoo | General Discussion | 3 | June 21st, 2005 04:27 PM |
| Calculate percentage based on cells with conditional formatting | Cachod1 | New Users | 5 | April 4th, 2005 02:11 PM |
Linear Mode
