If formula for conditional formatting

[jevi]

Hi All,

I am trying to do a formula with if and but I can't achieve what I want. I need if the cell I6 is Tuesday and Wednesday and if cell K5 is equal to 1,2,3,6,8,13,19,22,25 and that the cell K6 is bigger than zero, in case it meets these requirements the cell should be formatted red.

Is a table with the rows date and day of the month and then on the columns Codes which some are 1,2,3,6,8,13,19,22,25 and then I have all the data in tha table.

=+IF(AND($I6="Tuesday";$I6="Thursday";K5=1;K5=2;K5=3;K5=6;K5=8;K5=13;K5=19;K5=22;K5=24;K5=25;K6>0);FALSE)

I can't find a way to make it work.
thnx

 

[jevi]

Hi VBasic2008,

For the year 2021, the problem got complicated from my bosses so I have to do another formula for the conditional formatting but is not working.

I6 is the column with day from Monday to Sunday and I have it next to the column of date column H (from 01-31).
K5 is the row that has the branch codes. K6 is where the values are. The days are written are the ones that the tranx are closed as I need to check if they respect the closed days.

=AND(OR($I6="Mercoledì");OR(K$5=0;K$5=20;K6>0);AND(OR($I6="Martedì";$I6="Giovedì");OR(K$5=1;K$5=2;K$5=4;K$5=5;K$5=6;K$5=15;K$5=18;K$5=21;K$5=26;K$5=29);K6>0);AND(OR($I6="Martedì";$I6="Mercoledì";$I6="Giovedì");OR(K$5=3;K$5=8;K$5=10;K$5=11;K$5=13;K$5=16;K$5=19;K$5=22;K$5=24;K$5=25;K$5=28;K$5=33;K$5=35;K$5=37;K$5=38;K$5=39;K$5=40);K6>0);AND(OR($I6="Lunedì";$I6="Mercoledì";$I6="Venerdì");OR(K$5=30;K6>0)))

I did them 4 separately but still is not working. Maybe because the closed days are repeated. I can't find the problem.

Thank you,