I need to set conditional formatting where A1 is formatted to bold if B1 =
"Open",
same for A2 if B2 = "Open", A3 if B3 = "Open" and so on.

Is there a way I can do this formatting all at once as oposed to formatting
each "A" cell individually