Conditional formatting highlighting incorrect rows

Question

Hello!

I am having an issue where i am attempting to highlight blue all rows where the hospital unit is A2 but for some reason it is missing some of the A2 rows and erroneously highlighting others. Any advice?

Thanks

Answer 1

If you selected entire column, you should use C1 in your formula which is the first cell of your selected range.

=$C1="A2"

Answer 2

try this

please check the "applies to" in the first section of conditional formatting , you might have selected row1 ... so cell address displayed will be something like =$A$1:

change the 1 to 2 .. ie. $A$2

Answer 3

here is an image of my file - the original post would not let me upload. Thanks!