Hey!
In one row, I would like to do the following.
If A3 has any writing in it, but B3 does not, turn the entire row blue...but if A3 and B3 both have writing in them, then the row should remain clear or just no background color.
And if A3 is equal to the word "Pending" then turn the entire row pink.
And if nothing is written in A3 or B3 then the row is just clear.
Does anyone know how to do this?
I tried conditional formatting and for the first part I got it, but to do the pending part, another statement just won't work.
Any help?
In one row, I would like to do the following.
If A3 has any writing in it, but B3 does not, turn the entire row blue...but if A3 and B3 both have writing in them, then the row should remain clear or just no background color.
And if A3 is equal to the word "Pending" then turn the entire row pink.
And if nothing is written in A3 or B3 then the row is just clear.
Does anyone know how to do this?
I tried conditional formatting and for the first part I got it, but to do the pending part, another statement just won't work.
Any help?