Conditional Formatting Blank Cells

adelao747

New Member
Joined
May 9, 2017
Messages
12
Hello,

Does anyone know how I could use conditional formatting for highlighting blank cells? Basically, I have cells with a letter X and other cells that are blank. I want to use conditional formatting to highlight the borders red if the cells are empty. For some reason it only seems to work with highlighting the cells. But I only want the borders to be highlighted. It for some reason highlights all the cell borders, even when there is a letter X there. Anyone have any advice?

Thanks so much!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
when you select your range and use CF to identify the blank cells are you using something like =A1="" where A1 is the top of your selected range?

Then when you click format and click the tab that says border, make sure when you select your color i.e. Red there are four blue buttons around the box that says TEXT in the middle make sure you select all of them or the box will remain black.

HTH ~DR
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,171
Members
453,021
Latest member
Justyna P

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top