Conditional formatting alternative

C

cfmartin76

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?
 
F

Franz Verga

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?
Click to expand...



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
 
E

el.cuervo76

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?
 
Top