Conditional Formatting to highlight first cell in a row that is not null

[kat517]

I am trying to create a conditional formatting rule to highlight the first cell in the row with a value (or that is not blank/null). See below. See below - I would like the formula to populate as noted below. The spreadsheet is trying to list projects by weeks and hours. I would like each project to highlight the first cell in which there are hours.

I have looked for solutions online, and found a solution for a similar request but in columns, but I tried to replicate with no luck.

 

[SanjayGMusafir]

I tried =AND(B2="",C2<>"")

I gave you different formula and used it in a different way.

I clearly told which range to select and what formula to use -

Select Range from B2:I4 and use following formula to conditional format. Try it and revert

=And(A1="",B2<>"")