Hello

Can anyone tell me if it is possible to format a cell so it highlights after
another cell has been populated.

i.e

DH10 becomes a certain colour if text is populated in DG10, the problem is
there is no standard or expected text going in DG10 so the normal conditional
formatting rules I know don't work.

Many thanks

Julie

Try using this formula to apply CF to DH10...

=LEN(DG10)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion