Conditional formatting . . .

  • Thread starter Thread starter Fable
  • Start date Start date
F

Fable

Greetings,

Is their a way to set conditional formatting to an Shape (Circle
Square, Triangle etc)

I have Layout of an event drawn out on spread sheet with Tables an
chairs (drawn with auto shapes), below the layout I have a check lis
with the following headers TABLE and SEAT1, SEAT2, SEAT3, SEAT4, SEAT5
AND SEAT6. Under TABLE is the simply the table number e.g. 1-50 and eac
SEAT# has a status e.g. “Vacant”, “Occupied”, ‘Courtesy”.

Is it possible for example that my occupied seats turn red when th
text “Occupied” is entered in the check list?

Appreciate any help
 
You will find lots of shapes in the webdings, and wingdings fonts,
first you have to choose a character in a font
http://www.mvps.org/dmcritchie/rexx/htm/fonts.htm

c = CHR(129) 'filled triangle pointing up in webdings 3 font
c.Font.Name = "wingdings 3"

You can find additional Font information concerning Excel in
http://www.mvps.org/dmcritchie/excel/font.htm

Because you have to change the content (change a character)
you will not be able to use Conditional Formatting, but you can
use a Change Event macro if you can relate your change to
a specific change in another cell (manual change not a formula).
http://www.mvps.org/dmcritchie/excel/event.htm#case

Changing a value through a drop down list will require at
least Excel 2000. (Debra Dalgleish, contextures.com, posted
something recently about that).

If you limited yourself to 3 color changes for instance with no
change to content, for instance you appear to have 3 choices
with vacant, occupied, courtesy which might lend themselves
to Conditional Formatting, but watch out that it isn't going to be
distracting. http://www.mvps.org/dmcritchie/excel/condfmt.htm
You can change boldface, italics, colors (font, and/or interior),
but you cannot change number formatting, or content with C.F.
 
Back
Top