I am trying to conditionally format a table. I have a table of tax reports that need filing by company, date, form, state, period ending, due date, date filed and initials of the filer. I would like to format the rows so that when either the date filed or the initials of the filer is populated, the whole row will be we highlighted. I have found out how to do this by writing the formula for one row while making the date filed greater than 0. Do I need to write a new rule for each row? I tried to select the whole table, but then it highlights the whole table because of one cell. Say I want H2>0, I want A2:J2 highlighted and same per row.