How to create conditional formatting based on todays date and a column...

[401k]

Hello all!

I have a fairly simple pacing spreadsheet where I track metrics for my company. I'd like to turn a cell green if it's above the daily pacing, yellow if it's exact, and red if it's below the daily pacing. Essentially, I'd like the cell F3 to highlight based on today's pacing number. I'm positive I'm making it more difficult than it needs to be and I can't seem to get the formula correct!

Many thanks!

0352ee63582a07528ab29a843e0849ddce765ff311677117fb3dc4b28a4461be8351946da0224940a3b564db52666d04.png

[etaf]

Is the Pacing % you are comparing in column A
Not sure i understand the terminology

So you want to get the value from column A % for todays date and compare to the value in F3

conditional format rule for Green
=COUNTIFS(A8:A35,">"&$F$3,B8:B35,TODAY())

Another rule for yellow
=COUNTIFS(A8:A35,$F$3,B8:B35,TODAY())

Another for red
=COUNTIFS(A8:A35,"<"&$F$3,B8:B35,TODAY())

however, you have a formula in A and getting an exact match maybe difficult - so you may want to consider a range withing
say -0% + 0.5% for Yellow
maybe something like
=COUNTIFS(A8:A35,">="&$F$3, A8:A35,"<="&$F$3+0.005,B8:B35,TODAY())
OR maybe if under by 0.5%
=COUNTIFS(A8:A35,">="&$F$3-0.005, A8:A35,"<="&$F$3,B8:B35,TODAY())



anyway
heres the sheet
with the 3 rules as requested