dates leave cells blank

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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!
 
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
 
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
 
Back
Top