ExcelBanter - If And Statements

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

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

- - If And Statements (https://www.excelbanter.com/excel-programming/404116-if-statements.html)

If And Statements

How do i make a conditional formatting formula that says....

If B3 has an "X" in it and C3 is blank, fill C3 in red...

Thanks!!

Jim Thomlinson

If And Statements

Change from Cell is to Formula is and add this formula...

=And(B3="X", C3="")
--
HTH...

Jim Thomlinson

"JC" wrote:

How do i make a conditional formatting formula that says....

If B3 has an "X" in it and C3 is blank, fill C3 in red...

Thanks!!

If And Statements

Awesome!! THis worked!!! Thank-You very much!!!

"Jim Thomlinson" wrote:

Change from Cell is to Formula is and add this formula...

=And(B3="X", C3="")
--
HTH...

Jim Thomlinson

"JC" wrote:

How do i make a conditional formatting formula that says....

If B3 has an "X" in it and C3 is blank, fill C3 in red...

Thanks!!

All times are GMT +1. The time now is 07:48 PM.