Conditional Formatting Formula

G

Guest

I want to format a row based on the conditions of 2 cells. For example, if
cell A1 and B1 are not blanks, then row A1:F1 could be color "red". In
conditional formatting under formula, I have "AND(A1<>" ", B1<>" "). It is
not working. Thanks for your help in advance.
 
G

Guest

Be careful of blank characters and you may want to add the trim function...

=AND(Trim(A1)<>"", Trim(B1)<>"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting macro: simple, but doesn't work 6
Conditional Formatting with VBA 4
Duplicate Digits 3
Row number changes in conditional format formula during VB executi 2
IF - formatting problem 8
Number Of Cells Between Colored Cells? 1
How do I reference cells in CF formula within loop 2
Copy conditional format colors to another cell 2

Top