Conditional Formatting
Thanks Mike, works great.
"Mike H" wrote:
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
|