Conditional Format?

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
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
 
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)
 
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
 
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
 
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
 
Back
Top