Thanks for posting in the Lucidchart community! In this case, you could use a formula in the rule in which all shapes that have the shape data value '1' = 'Manager' and NOT 'Title' = 'CEO' applies the conditional formatting. This may allow you to apply the formatting to all managers aside from the CEO. Let me know if this still does not solve the issue!
As for your second question, I'm not entirely sure I understand which document and sheet your are referring to. Are you referring to the imported sheet with your Org Chart data and the Lucidchart document? Let me know!