Conditional Formatting - Pivot Table

[GeorgeTimes]

Hi all,

I'm struggling with formatting a pivot table based on some conditions.

My Pivot table has Countries as columns and Date as Rows (will attach a screenshot).

I need to fill the cells with Red if Blank, however for some of the countries (i.e Egypt,Ethiopia) if Blank need to fill with Grey.

Is there anyway I can do this? I know how to format if cells are Blank, but I can only do it with 1 colour, don't know how to do it based on specific countries.
I also need this to work for next months as well (atm last month is July 2022 - column C, but next month will add a new month which will be in column D and so on..)

 

[SanjayGMusafir]

Hi all,

I'm struggling with formatting a pivot table based on some conditions.

My Pivot table has Countries as columns and Date as Rows (will attach a screenshot).

I need to fill the cells with Red if Blank, however for some of the countries (i.e Egypt,Ethiopia) if Blank need to fill with Grey.

Is there anyway I can do this? I know how to format if cells are Blank, but I can only do it with 1 colour, don't know how to do it based on specific countries.
I also need this to work for next months as well (atm last month is July 2022 - column C, but next month will add a new month which will be in column D and so on..)

In conditional Formatting Use Formula -

=And($A1="Egypt",$B1="")

and choose the format you want. Simple

 

[SanjayGMusafir]

In conditional Formatting Use Formula -

=And($A1="Egypt",$B1="")

and choose the format you want. Simple

In case of multiple countries use -

=And(OR($A1="Egypt",$A1="Ethiopia"),$B1="")

 

[GeorgeTimes]

In case of multiple countries use -

=And(OR($A1="Egypt",$A1="Ethiopia"),$B1="")

Thank for your reply. However this seems to not work.

Based on your formula, Egypt or Ethiopia needs to be in A1, however, they're in A55 and A57. Also, next month, their row number will change as I have different amount of countries every month, therefore I cannot specify A55=Egypt.

Any ideas?