formatting cell number based on previous cell number

[Guest]

I would like to format a cell to turn red and bold, when it is a number other
than the previous cell. And, I would like it to stay black when it is the
same number as the previous cell.

Ex.

A1=30 (Red & Bold)
A2=30 (Black)
A3=45 (Red & Bold)
A4=45 (Black)
A5=45 (Black)
etc.

 

[Guest]

You can do this with conditional formatting.
Select cell A2, then Format > Conditional Formatting. Use the drop-down and
text box to make your condition 'Formula Is' '=(A2=A1)', then select the
format you want (red bold text) and click OK. Then use the format painter to
copy the format from A2 to other cells in the column.

 

[Guest]

Thank you for your extremely quick response. Your solution worked to a
degree...I would like if format the opposite way. With your wonderful
suggestion it currently does:

A1=30 (black)
A2=30 (red/bold)
A3=45(black)
A4=45(red/bold)
A5=45(red/bold)

Is there a way to say '=(A2NOTEQUALA1)' as opposed to '=(A2=A1)'?

 

[Guest]

Ok, so with a little bit more research I found that '=NOT' was the answer I
was looking for. So the formula should read '=NOT(A2=A1)' to acheive the
desired results. Thank you so much for your help, I was really stumped
before you lead me in the right direction!