Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff. 		Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Lista de useri | Reguli | Cauta | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat. 		Nou pe simpatie:
anais21 pe Simpatie.ro
Femeie
24 ani
Iasi
cauta Barbat
25 - 38 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Color Cells in Range if Values Exist in Other Range [Cond frm] Moderat de TRaP, TonyTzu  
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 3 ani
Postari: 523
Select the cells you want to color if their values exist in the other range, eg. B4:B81, go to Conditional Formatting - New Rule - Use a formula to determine which cells to format.

Set your desired formatting, then in the formula add something similar to: =COUNTIF($C$4:$C$35;B4)>=1
pus acum 10 zile
   
Pagini: 1    
Mergi la