MS Excel

Téma: Conditional formating - 2 lists

Zaslal/a Opicakuz 16.10.2014 23:52

Hi guys, can you solve this problem?

List 1
A1 = 11
A2 = 12
A3 = 13

List 2
A5 = 11.1.
A6 = 12.1.
A7 = 18.5.
A8 = 13.6.

I need to use conditional formatting to fill A1, list 1 with red color if the A5, list 2 contains text "11.1.", A2, list 1 with red color if the A6, list 2 contains text "12.1." etc.

If there's number in list 1 with has no "date conectivity" with the date in list 2, there shouldn't be red color.

Can you help me please?

Zaslat odpověď >

AL(17.10.2014 9:14)#021923

Could you upload zipped excel file in order to let us see (number) formats in both sheets? Solution depends on formats mentioned. What shall happen with A1 if 11.1. is in A6 instead of A5? Better description of your problem would be needed, I suppose.citovat

lubo(17.10.2014 10:26)#021924

A1, Condition

=List2!A5=A1&".1."citovat

Uživatelské menu

Nejste přihlášen(a)

Formulář Faktura

Formulář Faktura IV

Oblíbený formulář Faktura byl vylepšen a rozšířen.
Více se dočtete zde.

Helios iNuvio

Používáte podnikový systém Helios iNuvio? Potřebujete pomoci se správou nebo vyvinout SQL proceduru? Více informací naleznete na stránce Helios iNuvio.