Conditional Formatting and Empty Cells

[falcios]

I have this formula and I have applied conditional formatting
=IF(D41=D40,"Change","")

Conditional formatting is to bold and fill cell with yellow color if Change is in the cell.
When I drag the formula down to the whole range, the conditional formatting has been applied to the numbers that changed as well as empty adjacent cells.

I don't want to see the word change if the adjacent cell is empty.
How can I do this?

Thanks in advance.

 

[arthurbr]

You should add a condition to your formula providing for empty cells. I don't understand whet you mean by "adjacent cell" , but something based on

=IF(AND(D41=D40, D41<>"",D40<>""),"Change","")

should do?

 

[falcios]

You should add a condition to your formula providing for empty cells. I don't understand whet you mean by "adjacent cell" , but something based on

=IF(AND(D41=D40, D41<>"",D40<>""),"Change","")

should do?

Thanks arthurbr, that formula worked perfectly.

I meant by adjacent cells, the cell is empty either to the left or right of the cell

 

[arthurbr]

You're welcome