Select the cells, starting with A1, and goto FormatConditional Formatting
and change the condition to Formula Is, add a formula of
=LEFT(A1,1)=" "
click Format, select Pattern, and pick the red.
OK out.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bvinternet" wrote
in message ...

::Hi,
I have a spreadsheet with circa 11,000 rows, approx. 6 columns.
Some of the data MAY contain values that begin with a blank space,
e.g. the cell may look like (ignore quotes)

\" Fred\"

when it should be

\"Fred\"

Is there an easy way to change the cell colour to Red for all cells in
a spreadsheet where the first character is blank ?

Thanks in advance for your kind help.

Matt::


--
bvinternet
------------------------------------------------------------------------
bvinternet's Profile:
http://www.excelforum.com/member.php...o&userid=25525
View this thread: http://www.excelforum.com/showthread...hreadid=389620