Does a highlight row comand exist for Excel conditional formulas?

[Jeff]

I am trying to write a conditional formula and if a certain condition is met,
the entire row will be highlighted. Essentially, I am searching through a
suspense database and if a task is overdue I would like the conditional
formula to highlight the row. Here is what I am trying to do...

=IF(AND(B5<=TODAY(),I5<>"Closed"),highlightrowcolor=yellow,"")

Obviously the "highlightrowcolor" is not a command but if someone knows what
would work I would appreciate it tremendously if you could share that
information.

Thanks in advance,
Jeff

[Bernard Liengme]

Select the row
Go to Format|Conditional Formatting and enter the formula
AND(B5<=TODAY(),I5<>"Closed"), and set the formatting as needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeff" <Jeff@discussions.microsoft.com> wrote in message
news:35CE0570-3A65-4DB8-A31C-2DBE6D56B505@microsoft.com...
>I am trying to write a conditional formula and if a certain condition is
>met,
> the entire row will be highlighted. Essentially, I am searching through a
> suspense database and if a task is overdue I would like the conditional
> formula to highlight the row. Here is what I am trying to do...
>
> =IF(AND(B5<=TODAY(),I5<>"Closed"),highlightrowcolor=yellow,"")
>
> Obviously the "highlightrowcolor" is not a command but if someone knows
> what
> would work I would appreciate it tremendously if you could share that
> information.
>
> Thanks in advance,
> Jeff

[Barb R.]

Select the rows that you want to format
Format -> Conditional Formatting
Select FORMULA for the conditional format and enter this:
=AND($A5<=TODAY(),$I5<>"Closed")
Change the format for the cells that meet the condition to the background
color you want.

That should do it.

"Jeff" wrote:

> I am trying to write a conditional formula and if a certain condition is met,
> the entire row will be highlighted. Essentially, I am searching through a
> suspense database and if a task is overdue I would like the conditional
> formula to highlight the row. Here is what I am trying to do...
>
> =IF(AND(B5<=TODAY(),I5<>"Closed"),highlightrowcolor=yellow,"")
>
> Obviously the "highlightrowcolor" is not a command but if someone knows what
> would work I would appreciate it tremendously if you could share that
> information.
>
> Thanks in advance,
> Jeff