Hi,
I would like help with conditional formatting.
Basically I have a list of items in Column A - take it as shopping
Column B is where I would enter anything, so maybe paid, unpaid, receipt etc.
If Column B shows any text, I want the adjacent cell in Column A to highlight green.
e.g.
If A3 says Bread, B3 says collected A3 would turn green
A4 says Pasta, B4 says delivered A4 would turn green
A5 says Milk, B5 is blank, A5 would stay clear
I used the formula:=B3=""
However this only highlights the empty cells.
When I tried: =B3="<>"
The cells all go blank
Any help would be appreciated.
Bookmarks