IF statement to return a text string linked to conditional formatting

[MarkR3003]

Could you please advise if its possible to have an IF formula statement in cell B7 when two conditions are true, one of which is using conditional formatting (red bold text based on a formula condition in another validation cell)?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NAME[/TD]
[TD]TITLE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mark[/TD]
[TD]Manager[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]NAME[/TD]
[TD]DEPT[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Tom[/TD]
[TD](blank)[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]RESULT
[/TD]
[TD]NOK[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 307"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Condition 1: Cell has conditional formatting applied (Red and Bold text) i.e A2 and A5 (I have multiple cells which are not adjacent to each other)
Condition 2: Cell to the right of condition 1 cell is not blank i.e B5
Result: If B2 or B5 are blank = "NOK". If both B2 and B5 contain a text or number = "OK"

Many thanks for your help as always

Mark

 

[Eric W]

What's the rule for determining if values in column A are bolded in red? We can probably incorporate that into the B7 formula, but there's no formula way to determine if a cell has Conditional Formatting applied.