Re: Excel 2000

• Previous message: Adam Hauner: "Re: Prehrac CD s CD-TEXT"
• Maybe in reply to: Frantisek Vosika: "Excel 2000"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> Zustal bych u toho podmineneho formatovani, obycejnym vzorcem to nepujde,
> a pak uz jen zbyva napsat si nejake to makro.
>
> Kdyz se kouknu do podmineneho formatovani, muzu volit mezi zavislosti na
> 'hodnota bunky' (nejspis aktualni), nebo vzorcem, takze neni co resit.
>
>
> Priklad:
> Bunka A1 ma podminenym formatovanim nastevne pozadi na cervenou, pokud je
> splnen nasledujici vzorec:
>
> =KDYZ($F$4="ok";PRAVDA;NEPRAVDA)
>
> No a kdyz do F4 naposu "ok", bunka A1 ma cervene pozadi, kdyz 'ok'
vymazu,
> nema zadne.
>
> Ted jsem to zkousel, funguje to.
>
> PS: Pokud mas eng excel, preloz si ten vzorec.
  KDYZ     = IF
  PRAVDA   = TRUE
  NEPRAVDA = FALSE

> -pp21-

Diky moc, presne to je ono.

Vamp

• Previous message: Adam Hauner: "Re: Prehrac CD s CD-TEXT"
• Maybe in reply to: Frantisek Vosika: "Excel 2000"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 18. 12. 2002, 14:11 CET