Unfortunately I cannot grasp how the conditional formatting works. I have a sheet like that:
I have defined 2 cell styles "Low" and "High" and I want cells in columns A-E to have one of these styles applied if the cell in column G has a value "L" or "H" respectively. If anything else is put there the cells shall stay white as they are.
For the demonstration purposes I a have manually applied the styles to the example rows.
Perhaps I am doing something wrong, but whatever I do either some cells do not have the proper style applied or some other cells have the style also applied. I was not able to achieve the desired result.
Could you please describe the exact steps to obtain the desired formatting...