Hello everyone!
I'm not very good at explaining things but I am trying to set up a rule to highlight a cell based on if it is blank (and it shouldn't be if another cell related to it is not blank.)
So for example if B2 in the attached has an Item in it but C2 is blank then I want to highlight this in a colour. I managed to do this but what happened was that all the C column cells were then highlighted regardless of whether there was anything in column B or not (unless I then filled in column C and not every line will need this)
Thanks very much!