EXACT function

[excellence]

I am trying to conditionally format a table a5:c24 using the EXACT function so that whenever the contents of d1 (the value of d1 is text and is the word TIME) is in this range (case sensitive) it gets highlighted.

I can't figure how to change the $A5 to something like $A5:$C5...so it would include all 3 columns. I realize I could make 3 rules, but rather have just one.


=EXACT($A5,$D$1)

Many thanks

 

[BSALV]

Map1
	A	B	C	D
1				Time
2
3
4	Time
5
6
7
8
9
10
11
12
13
Blad2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C24	Expression	=GELIJK(A1;$D$1)	text	NO

in english =exact(A1,$D$1)

 

[AhoyNC]

Try:

Book1
	A	B	C	D
1				TIME
2
3
4
5	TIME
6
7			TIME
8
9
10	ty		time
11		TIME
12
13
14
15
16
17
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5:C24	Expression	=EXACT($D$1,A5:C24)	text	NO

 

[excellence]

Sorry, but I don.t understand. I should have mentioned I am on a mac, and thought a rule under conditional formatting would solve it. Your pic is unfamiliar to me though similar to mac.
Thanks

 

[excellence]

no luck

 

[AhoyNC]

Are you going to
-Conditional Formatting
-New Rule
-Use a formula

 

[excellence]

Here are couple of pics of what I have, one showing the conditional window with three 3 rules, there i 1 for col a, b, c as well as one of the rules. Is it possible to have 1 formula that will take the range and highlight each cell individually when there is a match?

 

[excellence]

sorry bout that but Mr Excel knocked me off before I had chance to delete the pic above ...above should read .....there is 1 for....

Here are the pics

 

[excellence]

Are you going to
-Conditional Formatting
-New Rule
-Use a formula

View attachment 58274

yes

 

[AhoyNC]

Was my post#3 above what you are trying to do?
If so change your formula to:
EXACT($D$1,A5:C24)