Filling backcolor cells color based on the color of a cell

[jgalas]

I want, based on the color of one cell (red), to fill the 5 cells below (pink). As picture.

The cell background (red) is defined by CF.
=IF($A81="calendar";IF(MONTH(Calendar!$F$23)=$C82;DAY(Calendar!$F$23);-1);IF($A81="calendar_bi";IF(MONTH( Calendar!$AK$23)=$C82;DAY(Calendar!$AK$23);-1)))

It will be applied to several rows.

Thank you in advance for any help

 

[jgalas]

that requires a log in and has unavoidable tracking, so it is definitely not the simplest way to share files.
Can't you use drop box, google docs, or have a microsoft OneDrive folder?

Dropbox File

Dropbox Same File

DropBox Transfer

 

[awoohaw]

Thanks for dropping the file I have downloaded them.

I have looked at them and there are #VALUE errors in rows 9, 15, and others for which you wanted the CF reviewed.
I'll try to figure out what you want.

I do have a really big question!!!:
In ROW 15 you have a calculation. You said you changed nothing except ROW 15. But in order to change the value of J15 and keep that formula there you would have needed to change a value somewhere else.

Please explain.

 

[jgalas]

Dropbox File

Thanks for dropping the file I have downloaded them.

I have looked at them and there are #VALUE errors in rows 9, 15, and others for which you wanted the CF reviewed.
I'll try to figure out what you want.

I do have a really big question!!!:
In ROW 15 you have a calculation. You said you changed nothing except ROW 15. But in order to change the value of J15 and keep that formula there you would have needed to change a value somewhere else.

Please explain.

The value change in sheet "Turma", cell L9
It´s the only change
Everything else changes automatically