conditional formatting - simple!!!!

nsutton

Board Regular
Joined
Nov 12, 2010
Messages
63
This is probably a very simple one and im being stupid!.

In the conditional formatting options how do you select the criteria to occur when the cell is empty??

regards
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Sektor

Well-known Member
Joined
May 6, 2011
Messages
2,834
Better use:
=ISBLANK(A1)

=A1="" won't work if function returns empty string.
 

nsutton

Board Regular
Joined
Nov 12, 2010
Messages
63
Neither of those worked :( its cell value is empty not cell formula. for example i might have a period of data from A1:D4, all cells may have data in EXCEPT C3 so all i want in the cell C3 to have the conditional formatting??
 

Sektor

Well-known Member
Joined
May 6, 2011
Messages
2,834

ADVERTISEMENT

Did you set the color when condition is met?
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Working here. Select all the cells then apply the CF

Excel Workbook
ABCD
1112
Sheet1
 

nsutton

Board Regular
Joined
Nov 12, 2010
Messages
63

ADVERTISEMENT

not working on mine grrr!. I go to conditional formatting and choose formula Is in condition 1 box and then type in the following =A1="" and all the cells have the formatiing whether empty or not!!!
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Are you sure they are truly blank and don't contain spaces.
 

nsutton

Board Regular
Joined
Nov 12, 2010
Messages
63
I think its working, It was because i wasnt starting my cell sections from A1 :( sorry
 

nsutton

Board Regular
Joined
Nov 12, 2010
Messages
63
no is it heck!! What am i doing wrong???

My data range i want this function to work on is E3:U187

All i want to happen is that every blank cell in that range i want to be highlighted.

the code =A1="" doesnt work nor does =E3=""

:(
 

Watch MrExcel Video

Forum statistics

Threads
1,122,418
Messages
5,596,028
Members
414,039
Latest member
southike

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
Top