Does a highlight row comand exist for Excel conditional formulas?
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"),highlightrowcolo r=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 |
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" wrote in message ... 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"),highlightrowcolo r=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 |
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"),highlightrowcolo r=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 |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com