Conditional Format?

[Ken]

Excel 2000 ... I wish to Conditional Format merged Cells
based on the 1st character (Alpha or numeric) appearing in
the Cell. How do I achieve this?

ie: Monthly ... would format based on the "M"

Thanks ... Kha

 

[Roger Govier]

Hi Ken

Select the cells concerned and choose Format=>Conditional Formatting select
drop down for Formula Is and in the white pane type
=LEFT(B4)="M"
Choose the Format you require

Note the cell reference e.g. B4 must be the top left cell of your range of
Merged cells

 

[Bob Phillips]

Ken,

Just set the condition to formula with =LEFT(A1,1)="M"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

You can only apply 3 formats (4 obviously if no conditional format is
counted and some more if you use formatted fonts for numeric values). If you
mean that if the cell contains Month you can use

=$B$B1="Month"

or

=LEFT($B$1)="M"


also considering not using merged cells, you can almost get the same look
using other means and somewhere
down the line merged cells can cause a lot of problems

 

[Ken]

Thanks ... I am now all set with this ... I guess I had a
brain cramp as I basicaly used this formula, but was
attempting to add wild cards ... Over thinking I
guess ... Anyway, thanks to your Magic ... I am all
set ... Kha

 

[Guest]

Ken,
To further Peo's comment about merged cells. If practicle, you should use Center_across_selection under horizontal alignment instead of merging cells. Unfortunatley, excel no longer has a tool button for center_across_selection. However, if you use it frequently it is worth writing a macro and assigning it to a button.

Regards,
Mark Graesser
(e-mail address removed)

----- Peo Sjoblom wrote: -----

You can only apply 3 formats (4 obviously if no conditional format is
counted and some more if you use formatted fonts for numeric values). If you
mean that if the cell contains Month you can use

=$B$B1="Month"

or

=LEFT($B$1)="M"


also considering not using merged cells, you can almost get the same look
using other means and somewhere
down the line merged cells can cause a lot of problems