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]

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

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

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=countifs($b2:b2,"<>")=1

 

[kat517]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=countifs($b2:b2,"<>")=1

I'm on Microsoft 365.

Unfortunately that formula highlights the first cell in each row instead of the first cell with a value.

 

[kat517]

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

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

Hi - thanks, but using that formula did not highlight anything. I tried =AND(B2="",C2<>"") but that highlights the cells in each row before the cell with the value (see below).

 

[Fluff]

Do you have a formula in those cells that returns ""

 

[kat517]

Do you have a formula in those cells that returns ""

Yes, the cells have a formula calculating hours/week but returns "" if the project falls outside of those dates. I tried to simplify the view for the thread, without realizing that might be critical info! Sorry about that.

Below is the file showing the formula in cell F3 which is used for columns F+.

 

[Fluff]

Ok, how about

=COUNTIFS($F3:F3,">0")=1

 

[kat517]

Ok, how about

=COUNTIFS($F3:F3,">0")=1

yes that worked! Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.