Taking the details from your subject line:
Select A2
Click Format Conditional Formatting
Under condition 1, make the settings:
Formula is: =B2<""
Click Format button Patterns tab Blue OK
Click OK at the main dialog
And, depending on how 'blank' is defined, alternative conditional format
formulae which could be used (from a recent post by Harlan):
=NOT(ISBLANK(B2))
or equivalently
=COUNTA(B2)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jon" wrote in message
...
If a cell contains any value I want a particular cell to change to a
different color.