Hello Everyone!
How to make conditional formatting through sheets.
Sheet 1:
a1 = name b1 = surname
a2 = name b2 = surname
a3 = name b3 = surname
etc ...
Sheet 2:
a1 = 1
b1 = -5
c1 = 4
etc ...
If the number a1 on sheet 2 is positive, then a1 is on sheet 1 green. If the number a1 on sheet 2 is negative, then a1 is on list 1 red, etc ...
The check range is from a1: c1 to sheet 2.
Best regards
Bookmarks