Conditional Format Cell

[MrDB4Excel]

Within a range of cells that are in a named range, called Date_Rate, there exists an exchange rate that equals the rate shown in a cell outside this named range. I want to apply conditional formatting to the one cell that resides inside this named range that equals the content of the cell outside this range.

Date_Rate range is:
=$A$4:$B$34,$D$4:$E$31,$G$4:$H$34,$J$4:$K$33,$M$4:$N$34,$P$4:$Q$33,$S$4:$T$34,$V$4:$W$34,$Y$4:$Z$33,$AB$4:$AC$34,$AE$4:$AF$33,$AH$4:$AI$34

The cell outside this range is G2. G2 gets its value from another excel file. You should notice that the value in A1 coincides with today’s date (in this case 15 March as seen in the attached xl2bb data).
You will also notice that today’s date has conditional formatting applied to have the text bold and magenta with a light blue fill.
Thus I want the exchange rate that appears next to today’s date to also have conditional formatting similar to the date’s conditional format.
Any help is much appreciated. I have spent now about hours scouring the web for an answer and have not found anything to help.

2015_CSOB-CZK.xlsx
	G	H
2	21.976900	0.000000
3	03-Day	March
4	01/Mar/21	21.706800
5	02/Mar/21	21.668100
6	03/Mar/21	21.686800
7	04/Mar/21	21.808200
8	05/Mar/21	22.115800
9	06/Mar/21	22.093200
10	07/Mar/21	22.093200
11	08/Mar/21	22.271900
12	09/Mar/21	22.066100
13	10/Mar/21	22.038200
14	11/Mar/21	21.851500
15	12/Mar/21	21.987100
16	13/Mar/21	21.890300
17	14/Mar/21	21.890300
18	15/Mar/21	21.976900
19	16/Mar/21	0.000000
MonthlyPensionHistory

Cell Formulas
Range	Formula
G2	G2	='F:\Finances\CSOB\[CurrencyConversionRatesWebQuery.xlsm]2021-ExchCalcs'!$S$3
H2	H2	=LOOKUP(2,1/(H:H<>""),H:H)
H4:H19	H4	='F:\Finances\CSOB\[CurrencyConversionRatesWebQuery.xlsm]2021-ExchCalcs'!E66

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:B34,D4:E31,G4:H34,J4:K33,M4:N34,P4:Q33,S4:T34,V4:W34,Y4:Z33,AB4:AC34,AE4:AF33,AH4:AI34	Dates Occurring	today	text	NO

 

[etaf]

if you select row H2:H19
then use
a formula for conditional formatting

=$G2=today()
use the format you want

example.xlsx
	G	H
1
2	#REF!	March
3	03-Day	March
4	3/1/21	#REF!
5	3/2/21	#REF!
6	3/3/21	#REF!
7	3/4/21	#REF!
8	3/5/21	#REF!
9	3/6/21	#REF!
10	3/7/21	#REF!
11	3/8/21	#REF!
12	3/9/21	#REF!
13	3/10/21	#REF!
14	3/11/21	#REF!
15	3/12/21	#REF!
16	3/13/21	#REF!
17	3/14/21	#REF!
18	3/15/21	#REF!
19	3/16/21	#REF!
Sheet2

Cell Formulas
Range	Formula
G2	G2	='/Users/wayne/Library/Containers/com.microsoft.Excel/Data/Documents/F:\Finances\CSOB\[CurrencyConversionRatesWebQuery.xlsm]2021-ExchCalcs'!$S$3
H2	H2	=LOOKUP(2,1/(H:H<>""),H:H)
H4:H19	H4	='/Users/wayne/Library/Containers/com.microsoft.Excel/Data/Documents/F:\Finances\CSOB\[CurrencyConversionRatesWebQuery.xlsm]2021-ExchCalcs'!E66

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H4:H19	Expression	=$G4=TODAY()	text	NO

 

[MrDB4Excel]

Perfect, thanks etaf. Exactly what is needed. You rock!

 

[etaf]

you are welcome