How to conditionally format first cell in the row in excel 2007

[aparanjith]

Hi, I am using a excel spreadsheet, where I want first cell of the row to turn red color, if there are any empty cells in the row.
That means if I have an empty cell in 3rd column of first row, then I want only the first cell of the row should turn to red, similarly this formula should apply for all the rows in the spreadsheet. can anyone help me out.

 

[Trouttrap2]

Highlight the cells you want formatted. Open your conditional format dialogue box. add this formula =COUNTA(C2:F2)<>COLUMNS(C2:F2). Format to red. You will need to change the ranges of the formuals.