Re: Conditional Formating by RagDyer
RagDyer
Fri Apr 18 14:42:18 CDT 2008
You're welcome, and appreciate the feed-back.
Also, check your system clock!
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Khalil Handal" <handalk@stthom.edu> wrote in message
news:OgFOHQYoIHA.4832@TK2MSFTNGP02.phx.gbl...
> Thanks for the help
>
> "RagDyer" <ragdyer@cutoutmsn.com> wrote in message
> news:uofatSPoIHA.2636@TK2MSFTNGP04.phx.gbl...
>>I don't follow what you mean when you say:
>> <<<"The condition is "and" in conditional formatting">>>
>>
>> Use "Formula is" with
>> =CELL("format",A1)="C2"
>> for Condition1
>> format to Red-
>>
>> Use "Formula is" with
>> =CELL("format",A1)=",2"
>> for Condition2
>> format to Green-
>>
>> --
>> Regards,
>>
>> RD
>>
>> ---------------------------------------------------------------------------
>> Please keep all correspondence within the NewsGroup, so all may benefit !
>> ---------------------------------------------------------------------------
>> "Khalil Handal" <handalk@stthom.edu> wrote in message
>> news:eyv$dUKoIHA.4580@TK2MSFTNGP03.phx.gbl...
>>> Works for some cells and doesn't work for other values in the range.
>>> Is there anything special????
>>> The condition is "and" in conditional formating which gives the
>>> impresion that it sould fulfill BOTH conditions!!!
>>>
>>>
>>> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
>>> news:O3GEi9JoIHA.2256@TK2MSFTNGP05.phx.gbl...
>>>> Say A1 is formatted for $'s,
>>>> And A2 for ?'s.
>>>>
>>>> In B1 enter:
>>>>
>>>> =Cell("format",A1)
>>>>
>>>> And copy down to B2.
>>>>
>>>> B1 returns < C2 >
>>>> And B2 returns < ,2 >
>>>>
>>>> SO ... conditional formulas such as:
>>>>
>>>> =CELL("format",A1)="C2"
>>>>
>>>> And
>>>>
>>>> =CELL("format",A1)=",2"
>>>>
>>>> should work for you for condition 1 and condition 2 formulas set with
>>>> your
>>>> colored formats.
>>>> --
>>>>
>>>> HTH,
>>>>
>>>> RD
>>>> =====================================================
>>>> Please keep all correspondence within the Group, so all may benefit!
>>>> =====================================================
>>>>
>>>>
>>>>
>>>> "Khalil Handal" <handalk@stthom.edu> wrote in message
>>>> news:%232y$zMJoIHA.1240@TK2MSFTNGP02.phx.gbl...
>>>> The cell are preformated as accounting: either dollars ($) or (?) .
>>>> When I enter a number in a cell it will automaticcly have the sign
>>>> shown.
>>>> Of course the cells contains different values.
>>>>
>>>>
>>>> "CG1954" <CG1954@discussions.microsoft.com> wrote in message
>>>> news:A71CB7CE-C328-46F3-932E-D31135602B9D@microsoft.com...
>>>>> Yes
>>>>> Use "cell value is equal to" in conditional formatting.
>>>>> You will have to ensure you use the required currency symbol ($ / ?)
>>>>> as
>>>>> you
>>>>> enter the the amount in each cell ie
>>>>> $12000
>>>>> ?12000
>>>>>
>>>>> CG1954
>>>>>
>>>>> "Khalil handal" wrote:
>>>>>
>>>>>> Is it possible to use conditional formatin in Excel 2003 to:
>>>>>> value cell is in red if it's format is accounting - Dollars
>>>>>> value cell is in blue if it's format is accounting - Euros
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>