Need help creating a formula that would help me color rows if they meet a over 50% value.

[ikkidono]

Hello all, I need help with excel.

I really don't know what I'm doing.

I need to create a formula that would highlight rows yellow if there is a grade posted in at least 50% columns D-S. Please see attachment for example.

[protonLeah]

Select the block of cells (D2:S11) you wish to CF and enter:
=COUNTA($D2:$S2)/16>=0.5

[Russell Dawson]

=COUNTA($D$2:$S$11)/16<=0.5

Make sure you delete the dashes in each empty cell as the Counta function looks for any cell that is not blank.

[Marcol]

If you are always going to have "-" when there is no grade entered then

Please Login or Register  to view this content.

If the cells with no entry could be either blank or "-"

Please Login or Register  to view this content.

If you choose to leave all cells with no entry blank then

Please Login or Register  to view this content.

In all cases COLUMNS($D$1:$S$1)/2 could be replaced with 8 i.e. the number of columns in D:S divided by 2.