ExcelBanter - Conditional Formatting Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional Formatting Formula (https://www.excelbanter.com/excel-programming/385071-conditional-formatting-formula.html)

Daviv

Conditional Formatting Formula

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.
--
Thanks!

Vergel Adriano

Conditional Formatting Formula

make sure you start with an equal sign.

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

"Daviv" wrote:

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.
--
Thanks!

Jim Thomlinson

Conditional Formatting Formula

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

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

--
HTH...

Jim Thomlinson

"Daviv" wrote:

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.
--
Thanks!

All times are GMT +1. The time now is 02:21 PM.