condtional format

G

gloriana

Hello

I am having trouble with conditional format. If the figure in the cel
is greater than 30 days it turns red. Fine no problem, but the 30 day
is a calculation of 2 other cells. I drag this formula down. So eve
though you cannot see the formula it turns the cell red as soon as
drag it down.

Any ideas please - most gratefu
 
F

Frank Stone

hi.
don't drag. copy and paste.
when you drag, the cell keeps the original references as
well as the conditional formating. copying and pasting
will paste the conditional format but will change the cell
references.
Regards
Frank
 
G

Gord Dibben

Rather than drag/copying I would suggest using the Format PaintBrush to copy
the CF to the other cells, but not knowing exactly what you have in the other
cells...............??

Gord Dibben Excel MVP
 
Top