Conditional Formatting For first row with some conditions

[kprabhupaul]

Hi Everyone,

I want to format a row (and columns range A to C)

1. Marks should be 100

2. Candidate should not be in Previous Winners

Pls find the link, and help me

https://docs.google.com/spreadsheets/d/1Wxxc19NF9IsBPyUEuozYKdkatLqZUFV09J-xhLcXCaM

Thanks in Advance

[mehmetcik]

A4 = New Winner

You probably need to use Ctrl Shift Enter to enter this formula.

This will change whenever the sheet is calculated.
D4 =IF(COUNTIFS(B:B,"=100")>0,INDIRECT("A" & LARGE(IF(B7:B16=100,ROW(B7:B16),0),RANDBETWEEN(1,COUNTIFS(B:B,"=100")))),"No Winner")

Conditional Formatting rule for A7:C16 =$A7=$B$4