Highlight a single cell based on criteria in different sheet

[Gaurav Tripathi]

Hi,

I have to highlight a single cell K23 RED or GREEN in first sheet (Daily Report) depending upon a criteria. The criteria is as follows:

1. In sheet 'Entry', date in B column is equal to date in 'K2' of 'Entry'
2. In sheet 'Entry', Value in S column is 'Yes' (for any abnormality) in the same date.

I tried for 4-5 days but not successful. Please help.

Regards,

Gaurav

 

[Khalid NGO]

Hi Gaurav,

If you only need to highlight cell K23
Fill GREEN color in K23 then apply conditional formatting i.e. K23=0 (cell color = RED)

 

[Gaurav Tripathi]

Dear Khalid,

I already tried this. It is successful for only one row selection in sheet 'Entry'.
Not works when I change date in sheet 'Daily Report'.

 

[Gaurav Tripathi]

I DID IT.

It was simple. I use =IF(COUNTIF('PM Abnormality'!B:B,'Daily Report'!K2),"Yes","No") and then custom format according to "Yes" and "No".

Thanks!

 

[Khalid NGO]

Glad you have solved it by yourself.
Thanks for sharing answer.