I was able to highlight some cells using conditional formationg.
Unfrotunately the cells are not next to ehac other (there are blank
cells in the middle). Since I don't need those blank cells I can just
delete them or sort the column so all the cells with information move
to the top, the problem is that when I finish sorting and the cells
move up I lose the format I applied on conditional formatting.

is there any other way to apply format (change color) to a cell
depending on 2 other cells?

This is what I have:
Highlight in bold row 2 if A2 -a date- is between A1 -date #1- and
A2 -date#2-

However I want to maintain that format (bold highlight) even if I move
A2 to a separate column. Does it make sense?

(E-Mail Removed) wrote:
> I was able to highlight some cells using conditional formationg.
> Unfrotunately the cells are not next to ehac other (there are blank
> cells in the middle). Since I don't need those blank cells I can just
> delete them or sort the column so all the cells with information move
> to the top, the problem is that when I finish sorting and the cells
> move up I lose the format I applied on conditional formatting.
>
> is there any other way to apply format (change color) to a cell
> depending on 2 other cells?
>
> This is what I have:
> Highlight in bold row 2 if A2 -a date- is between A1 -date #1- and
> A2 -date#2-
>
> However I want to maintain that format (bold highlight) even if I move
> A2 to a separate column. Does it make sense?



Try to post a sample of your data and also the formula you used in
condtional formatting...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

This is how it looks:

A B
1 5/12/2006 5/20/2006
2 5/15/2006 APPLE
3 5/25/2006 ORANGE
4 5/12/2006 APPLE

The formula is:
=AND($A2>=$A$1,$A2<=$B$1) then the formating (bold). Once I set thie
conditional formatting, rows 2 and 4 will be bold. If I move cell B2
to a separate column I will lose the format. How can I keep the format?