conditional formatting - simple!!!!

[nsutton]

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

 

[VoG]

Use the Formula Is option like this

=A1=""

 

[Sektor]

Better use:
=ISBLANK(A1)

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

 

[nsutton]

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]

Did you set the color when condition is met?

 

[VoG]

Working here. Select all the cells then apply the CF

Excel Workbook
	A	B	C	D
1	1	1		2
Sheet1

 

[nsutton]

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]

Are you sure they are truly blank and don't contain spaces.

 

[nsutton]

I think its working, It was because i wasnt starting my cell sections from A1 sorry

 

[nsutton]

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=""