Conditional Formatting based on multiple cells

[brass312]

Guys I know that it should be simple:

I got for statuses for different categories in cells A1-A4

1 2 3 4 5
A ok ok ok ok

I want conditionaal formatting to color A5 in blue only if all 4 cells A1-A4 have 'ok' populated in them.
Just cannot figure it out..

 

[Momentman]

Use conditional formatting in A5 as =Countif(A1:A4,"ok")=4

 

[brass312]

Use conditional formatting in A5 as =Countif(A1:A4,"ok")=4

thanks, what if in another case I have different scenario:

Test 1	Test 2	Test 3	Test 4	Status
ok	ok	ok	completed

<tbody>
</tbody>

so I want A5 in blue when I have 'ok' in A1-A3 and 'completed' in A4

 

[Momentman]

=AND(COUNTIF(A1:A3."ok")=3,A4="completed")

 

[brass312]

=AND(COUNTIF(A1:A3."ok")=3,A4="completed")

works perfectly, thank you sir!