Hi,

Use 'Conditional Formatting'.

If B2 will contain only numerical values, do the following.
Click on A2, then "Format" (in the Toolbar) -- "Conditional Formatting" --
under 'Condition 1' change to "Formula Is" -- in the formula bar enter
=COUNT($B$2) -- click on the "Format" button -- "Patterns" Tab -- Select
the Blue color -- "OK" -- "OK"

An alternative formula that will also work is =ISNUMBER($B$2)

The above formula will color the cell A2 to blue if B2 contains a numerical
value (including zero); A2 will not be turn color if B2 is empty or contains
text.

If you want A2 to get colored when B2 contains any type of data (number or
text),
change the conditional-formatting formula as =COUNTA($B$2)
Please note however that even a space character (which you can't see) if
present in B2 will color A2 to blue.

Regards,
B. R. Ramachandran

"Jon" wrote:

If a cell contains any value I want a particular cell to change to a
different color.