conditional formatting

[jladika]

i have tryed to use this with three options
"A" "B" "C"

each haveing a color of its own
when i do this the "A" stays the same and the others trun as they wer
set up to do
if i change the letter that is in "A" to another letter it works ok

what with that??

 

[David McRitchie]

"jladika >" <<[email protected]> ,

And the information that you need to tell us about what you
are using is missing.

Which cell get colored are dependent on your selection
before entering the Conditional Formatting. The formula
used to determine if the cell is to be C.Formatted or not
is dependent of the formula returning True or False,
and the interpretation of the formla is based on the
active cell.

Suggest you look at the following
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Please read Chip Pearson's page on posting
http://www.cpearson.com/newpose.htm
and "Conditional Formatting" is too general for a topic
that has much uniqueness. If you don't have a unique
question you probably would find answers real quickly
in the newsgroup archives.

 

[jladika]

why dont the letter "A" change color?
If i change the letter in the CF then new letter changes colors
only the letter "A" dont change what do i need to do?