Hi,

This assumes age in col D expectancy in Col E. Select the rows to format and
then

Format|Conditional format
Formula is
=$D2$E2

Pick a colour
Change 2 to the top row of the range.

Mike


"sojuman" wrote:

I have a sheet that needs to compare AGE to LIFE EXPECTANCY. It also needs
to highlight the entire row when the age is greater than the life expectancy.


Thanks