Conditional Formatting Amendment

  • Thread starter Thread starter Rob Nance
  • Start date Start date
R

Rob Nance

Hello

I've currently got a condition as: Cell Value = CN, applied to $H:$H (ie a whole col) but I'd like to change that to "If first character of cell = C". Haven't done this for so long that I can't seem to get the formula right. :( Help?
 
Hi Rob,

Am Fri, 28 Mar 2014 14:12:24 -0700 (PDT) schrieb Rob Nance:
I've currently got a condition as: Cell Value = CN, applied to $H:$H (ie a whole col) but I'd like to change that to "If first character of cell = C". Haven't done this for so long that I can't seem to get the formula right. :( Help?
Click to expand...

try in conditional formatting "Formula to determine..." and enter the
formula:
=LEFT(H1,1)="C"


Regards
Claus B.
 
Hi Rob,



Am Fri, 28 Mar 2014 14:12:24 -0700 (PDT) schrieb Rob Nance:






try in conditional formatting "Formula to determine..." and enter the

formula:

=LEFT(H1,1)="C"





Regards

Claus B.

--

Vista Ultimate SP2 / Windows7 SP1

Office 2007 Ultimate SP3 / 2010 Professional
Click to expand...

Thanks, Claus. Worked for that condition and I've amended it accordingly for other conditions in the column and it seems to be working for them too - so far!
 
Back
Top