If is blank= conditional formating

M

Markitos

Hello

I was trying to make a formula to conditional format a cell. I wanted the
formula to be (if the cell is blank). I wanted to make the cell have a red
border if it was blank. I know how to make make the border red if the
condition is true, but im not sure how to write the formula for this.

Thanks for your help.
 
M

Markitos

Thanks for your answer it was of great help.
I found something rather hard though, I cant copy the formula to other
cells, I wanted a whole row to use this formula, but if I copy a cell to
others it doesn't change the formula to correspond with the new cell, its
leaving the cell # the same.

Thanks for your help.
 
Top