# I need to highlight if two cells in the same row are blank ....

#### netrixuser

##### Board Regular
To Explain, in Cell E1 I want the word "Check" to appear only if both Cells B1 and C1 are blank, if either B1 or C1 contain data there is no check to be done and Cell E1 should be blank. The data in columns B and C will most probably be a letter x.

Also, I am thinking that a tick in Cells B1 and C1 looks better than an x, would it be more difficult if the data in columns B and C were ticks (using the Windings Font)

cheers in advance for any help/assistance.

Regards

Netrixuser

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Hi, you're talking about a few different things here.

If you want to check that both B1 and C1 are blank, try
=if(B1&C1="","Check","")

If you want to check that both B1 and C1 contain the letter X and nothing else, try
=if(and(B1="X",C1="X"),"Check","")

If you want to check that both B1 and C1 contain a single tick in wingdings and nothing else, try
=if(and(code(B1)=252,code(C1)=252),"Check","")

Hi, you're talking about a few different things here.

If you want to check that both B1 and C1 are blank, try
=if(B1&C1="","Check","")

If you want to check that both B1 and C1 contain the letter X and nothing else, try
=if(and(B1="X",C1="X"),"Check","")

If you want to check that both B1 and C1 contain a single tick in wingdings and nothing else, try
=if(and(code(B1)=252,code(C1)=252),"Check","")

Thank you for the speedy reply - the first one works a treat for now, I will try the last one if I decide to use the ticks.

Replies
1
Views
421
Replies
6
Views
263
Replies
3
Views
185
Replies
6
Views
268
Replies
1
Views
284

1,203,070
Messages
6,053,368
Members
444,658
Latest member
lhollingsworth

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back