Conditional formatting highlight

[Joeun]

Hi,

My formula seem to be wrong. Can any one please help me check the formula.

Appreciate in advance.

Thank you.

https://drive.google.com/drive/folders/1GONwJfx01v_XZeHrg3burkBavuF3ffIJ?usp=sharing

 

[Joeun]

Did you try locking down the references like I showed in the last post and see if that solves your issue?

not working.

 

[Joe4]

I don't know how much more able I will be able to help without seeing your workbook.
As I mentioned before, I cannot download files from my current location, but I can from my home.
So, if you are able to upload a file to a file sharing site and provide the link, I can download it and take a look at it later in the day when I am at home.

 

[Joeun]

I don't know how much more able I will be able to help without seeing your workbook.
As I mentioned before, I cannot download files from my current location, but I can from my home.
So, if you are able to upload a file to a file sharing site and provide the link, I can download it and take a look at it later in the day when I am at home.

Hi Joe4

Below are the share link to the folder

https://drive.google.com/open?id=1GONwJfx01v_XZeHrg3burkBavuF3ffIJ

Thank you

 

[Joe4]

You have a few issues, including referencing the wrong column in your COUNTIF formula, not locking down the correct ranges, and using WILDCARDS in your criteria.
Remove ALL your current Conditional Formatting in your example, then do the following:
- Select the range B3:H4
- Go to Conditional Formatting and enter this formula:

=COUNTIF(INDIRECT("'[CFormating.xlsx]"&$A3&"'!$B$4:$B$10"),B$2)

- Choose your formatting color

This will only highlight the 4 cells that you have the check marks in.

 

[Joeun]

You have a few issues, including referencing the wrong column in your COUNTIF formula, not locking down the correct ranges, and using WILDCARDS in your criteria.
Remove ALL your current Conditional Formatting in your example, then do the following:
- Select the range B3:H4
- Go to Conditional Formatting and enter this formula:

=COUNTIF(INDIRECT("'[CFormating.xlsx]"&$A3&"'!$B$4:$B$10"),B$2)

- Choose your formatting color

This will only highlight the 4 cells that you have the check marks in.

Hi Joe4

Thank you for your help. The problem is solved

 

[Joe4]

You are welcome.
Glad we were able to get it all sorted out.