Hello, I am fairly new to conditional formatting and am having troubles creating a formula for the below scenario. I would like to color code the cells in column B thru G that are below a certain value (eg:5) , IF the text on Column A is "Closing Stock". I am attaching a test file for your reference. I have been trying =AND(A:A='Closing Stock,$B:$G<5), but that's not working. Any help to resolve this is greatly appreciated. Thank you
Manoj
Bookmarks