<SOLVED>nak tanya pasal excel

[sukalepak]

Assalamualakum...

Situasi:

____A_______B
1__400_____700

Macamna nak wat kalo jumlah kat A1 tu bila kurang 50% dari B1,A1 akan jadi kaler merah..


Hehe, harap paham soklan tersebut. tq2!

Guna Conditional Formating senang lps tuh letak formula nih..

bila A nyer value kurang 50% dari B dia kan merah font dia

=$A$1/$B$1 <= 0.5

1. HOME tab -> Conditional Formating

2. New Rule -> Use Formula to determine which cells to format

3. Letak formula tuh , dan set kat format set.

 

[hurairah01]

guna conditional formatting

 

[sukalepak]

guna conditional formatting

tau, tapi nk setting tu yg agak x reti... kalo based on value tu reti, ni based on percentage..

 

[halim1988]

guna conditional formatting

yup..betul tu

 

[hurairah01]

tau, tapi nk setting tu yg agak x reti... kalo based on value tu reti, ni based on percentage..

wat calculation kat cell C1, A1/B1.. convert pada %.

 

[sukalepak]

yup..betul tu

tau, tapi nk setting tu yg agak x reti... kalo based on value tu reti, ni based on percentage. :">:">

 

[sukalepak]

wat calculation kat cell C1, A1/B1.. convert pada %.

boleh bagi contoh tak? upload, hehe.. :">:">

 

[badzkun]

Guna Conditional Formating senang lps tuh letak formula nih..

bila A nyer value kurang 50% dari B dia kan merah font dia

=$A$1/$B$1 <= 0.5

1. HOME tab -> Conditional Formating

2. New Rule -> Use Formula to determine which cells to format

3. Letak formula tuh , dan set kat format set.

 

[sukalepak]

Guna Conditional Formating senang lps tuh letak formula nih..

bila A nyer value kurang 50% dari B dia kan merah font dia



1. HOME tab -> Conditional Formating

2. New Rule -> Use Formula to determine which cells to format

3. Letak formula tuh , dan set kat format set.

yeeeee, jadi2... tq boss.. hebat la boss..

 

[badzkun]

yeeeee, jadi2... tq boss.. hebat la boss..

formula tuh bg adjust sikit , takut bg row bwh x tukar color

=$A1/$B1<= 0.5