BleepingComputer.com: Excel Conditional Formating And Formulas

Hello,

Could someone please help me, i have done a lot of work with excel, but have come across a problem that is driving me crazy.

What i am trying to do is i have a cell it has a "0" in it and the color of the cell is red, if i change the number to "15", the cell changes color to blue thanks to conditional formating.

But what i want to do now is if i change the "15" to BOLD, the cell will change color to green using conditional formating.

Does anyone know of a way to do this? Any solution would be greatly appreciated.

I simply need a way for excel to register that the number or letters have changed to BOLD and return a result.

I hope the above paragraph made sense with what im trying to do.

Cheers,

wce06

You can use a VBA code.

Sub teste()
	If Range("A1").Font.Bold = True Then
		MsgBox "oi"
	End If
End Sub

Thankyou,

that helped, i knew it would be something simple.

Regards