There are multiple files as sample file attached in a given folder.
In the following attached file ,Column F, following Conditional formatting required;
- Green Color filled to be removed,
- Cell with value BUY to be filled in Green and font color Red
- Cell with value SELL to be filled in Red and font color White
- The blank cell should have no color
Please