Good afternoon,
I'm new on this forum (and quite a newbe of excel), I've searched but didn't found any solution yet for my problem which is:
I want to fill my rows/line of a particular color regarding the result of a cell for each line. for example:
If A1 is = 1, then A1 B1 C1 D1 D1 will be all in RED / If A1 is = 2, then A1 B1 C1 D1 D1 will be all in GREEN
If A2 is = 1, then A2 B2 C2 D2 D2 will be all in RED / If A2 is = 2, then A2 B2 C2 D2 D2 will be all in GREEN
If a3 is =1 then A3 ....... etc
I can make it for one row using the conditional formatting but this is for one ligne only and I need it for approx. 100 row.
is there any formula like:
=IF(A1=1, A1:D1 COLOUR FULL RED,0)
Bookmarks