conditionally format using 2 criteria and non corresponding cells

[02100kara]

I created a calendar, I would like the days of the calendar to be formatted based on the profit or loss for that day. I figured I could have a query table that takes all the data from my main dataset and groups/sums the P&L by day, and then reference this table in a formula to format the calendar. Is this possible/ the best way? what should the formula be to do this?
I only need 3 formats, red if loss, green if profit, blue of $0.
There aren't any tutorials I've found that explains this issue. All I've seen is formatting data in adjacent rows, this is much more complex issue.

 

[6StringJazzer]

What is the formula in the cells of your calendar (B10:H15)? The important thing is whether it gives just the day of the month, or whether it gives a whole date formatted as "d".

Where is your "main dataset" with the P/L data? You may not have to create a helper table, depending on how your source data is organized. What is the formula in Q84 and downwards?

 

[02100kara]

What is the formula in the cells of your calendar (B10:H15)? The important thing is whether it gives just the day of the month, or whether it gives a whole date formatted as "d".

Where is your "main dataset" with the P/L data? You may not have to create a helper table, depending on how your source data is organized. What is the formula in Q84 and downwards?

thanks for helping, i got it now! this stumped me all day! using this:
=0=INDEX($P$83:$Q$733,MATCH(B10,$P$83:$P$733,0),2)
=0>INDEX($P$83:$Q$733,MATCH(B10,$P$83:$P$733,0),2)
=0<INDEX($P$83:$Q$733,MATCH(B10,$P$83:$P$733,0),2)

 

[6StringJazzer]

Glad you worked it out. I am surprised that just asking a couple of questions helped.