Conditional formatting . . .

[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

 

[Frank Kabel]

Hi
not possible with conditional formating. Only possible with event
macros

 

[Guest]

hi,
i dought that you can do the shaped. maybe the word
occupied.
see the sites for more info.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90
http://www.contextures.com/xlCondFormat01.html

 

[David McRitchie]

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.