I have one column A1:A25 for dates, dd/mmmm/yyyy. If cells A1, A2, A3 and
A4 require the date 04/03/2007 I want it to be able to be placed in A1 only,
while the other 3 cells are blocked or blank. The next different date
04/04/07 is in A4 but cannot be placed again in cells below it.

Our goal is to simplify the look of a complex spreadsheet so the eye can go
directly to one date. We will know every blank under a date is the same
date.

Is there a conditional format or other means to accomplish this?

Thanks for your time,
Gary

Set your conditional format to font color of "White" when a cell matches the
cell above it.

Select *A2* to A25, then:
<Format> <Conditional Format>,
Change "Cell Value Is" to "Formula Is" and enter this formula:

=A2=A1

Then click on <Format>,
And make the font color "White",

Then <OK> <OK>, and you should be done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gary" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have one column A1:A25 for dates, dd/mmmm/yyyy. If cells A1, A2, A3 and
> A4 require the date 04/03/2007 I want it to be able to be placed in A1
only,
> while the other 3 cells are blocked or blank. The next different date
> 04/04/07 is in A4 but cannot be placed again in cells below it.
>
> Our goal is to simplify the look of a complex spreadsheet so the eye can
go
> directly to one date. We will know every blank under a date is the same
> date.
>
> Is there a conditional format or other means to accomplish this?
>
> Thanks for your time,
> Gary
>
>

RD,

The formula works great, but somehow I keep doing it backwards. For
example, if I have 4 WED the first 3 are white fonts and the last one is
black. I can make my default font white, and then the conditional format
font black and it works. What might I be doing wrong?

Thanks,
Gary

"Ragdyer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Set your conditional format to font color of "White" when a cell matches
> the
> cell above it.
>
> Select *A2* to A25, then:
> <Format> <Conditional Format>,
> Change "Cell Value Is" to "Formula Is" and enter this formula:
>
> =A2=A1
>
> Then click on <Format>,
> And make the font color "White",
>
> Then <OK> <OK>, and you should be done!
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Gary" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I have one column A1:A25 for dates, dd/mmmm/yyyy. If cells A1, A2, A3
>> and
>> A4 require the date 04/03/2007 I want it to be able to be placed in A1
> only,
>> while the other 3 cells are blocked or blank. The next different date
>> 04/04/07 is in A4 but cannot be placed again in cells below it.
>>
>> Our goal is to simplify the look of a complex spreadsheet so the eye can
> go
>> directly to one date. We will know every blank under a date is the same
>> date.
>>
>> Is there a conditional format or other means to accomplish this?
>>
>> Thanks for your time,
>> Gary
>>
>>
>

RD,

I got it. I was not selecting the proper cell as the first part of the
formula. Sorry to bother, thanks again for the help,

Gary

"Gary" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> RD,
>
> The formula works great, but somehow I keep doing it backwards. For
> example, if I have 4 WED the first 3 are white fonts and the last one is
> black. I can make my default font white, and then the conditional format
> font black and it works. What might I be doing wrong?
>
> Thanks,
> Gary
>
> "Ragdyer" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Set your conditional format to font color of "White" when a cell matches
>> the
>> cell above it.
>>
>> Select *A2* to A25, then:
>> <Format> <Conditional Format>,
>> Change "Cell Value Is" to "Formula Is" and enter this formula:
>>
>> =A2=A1
>>
>> Then click on <Format>,
>> And make the font color "White",
>>
>> Then <OK> <OK>, and you should be done!
>> --
>> HTH,
>>
>> RD
>>
>> ---------------------------------------------------------------------------
>> Please keep all correspondence within the NewsGroup, so all may benefit !
>> ---------------------------------------------------------------------------
>> "Gary" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I have one column A1:A25 for dates, dd/mmmm/yyyy. If cells A1, A2, A3
>>> and
>>> A4 require the date 04/03/2007 I want it to be able to be placed in A1
>> only,
>>> while the other 3 cells are blocked or blank. The next different date
>>> 04/04/07 is in A4 but cannot be placed again in cells below it.
>>>
>>> Our goal is to simplify the look of a complex spreadsheet so the eye can
>> go
>>> directly to one date. We will know every blank under a date is the same
>>> date.
>>>
>>> Is there a conditional format or other means to accomplish this?
>>>
>>> Thanks for your time,
>>> Gary
>>>
>>>
>>
>
>

You're welcome, and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gary" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> RD,
>
> I got it. I was not selecting the proper cell as the first part of the
> formula. Sorry to bother, thanks again for the help,
>
> Gary
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> RD,
>>
>> The formula works great, but somehow I keep doing it backwards. For
>> example, if I have 4 WED the first 3 are white fonts and the last one is
>> black. I can make my default font white, and then the conditional format
>> font black and it works. What might I be doing wrong?
>>
>> Thanks,
>> Gary
>>
>> "Ragdyer" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Set your conditional format to font color of "White" when a cell matches
>>> the
>>> cell above it.
>>>
>>> Select *A2* to A25, then:
>>> <Format> <Conditional Format>,
>>> Change "Cell Value Is" to "Formula Is" and enter this formula:
>>>
>>> =A2=A1
>>>
>>> Then click on <Format>,
>>> And make the font color "White",
>>>
>>> Then <OK> <OK>, and you should be done!
>>> --
>>> HTH,
>>>
>>> RD
>>>
>>> ---------------------------------------------------------------------------
>>> Please keep all correspondence within the NewsGroup, so all may benefit
>>> !
>>> ---------------------------------------------------------------------------
>>> "Gary" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> I have one column A1:A25 for dates, dd/mmmm/yyyy. If cells A1, A2, A3
>>>> and
>>>> A4 require the date 04/03/2007 I want it to be able to be placed in A1
>>> only,
>>>> while the other 3 cells are blocked or blank. The next different date
>>>> 04/04/07 is in A4 but cannot be placed again in cells below it.
>>>>
>>>> Our goal is to simplify the look of a complex spreadsheet so the eye
>>>> can
>>> go
>>>> directly to one date. We will know every blank under a date is the
>>>> same
>>>> date.
>>>>
>>>> Is there a conditional format or other means to accomplish this?
>>>>
>>>> Thanks for your time,
>>>> Gary
>>>>
>>>>
>>>
>>
>>
>
>