Previous Topic Next Topic

Excel conditional formatting

[Solved/Closed]
Report
-
 G -
Hello,

if date in cell A1 appears anywhere from B1:B30 then apply format.

1 reply

Answer 1 / 1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
apply format where ?
could you explain a bit more
Report

Hey, sorry wasn't too clear. If date in cell A1 is repeated anywhere in cells B1-B30 then shade A1 a different colour.
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
Go to conditional Formatting
Enter this formula
=COUNTIF(B1:B30,"=" & A1)>0

In the conditional format dialogbox, click on format and choose the color
Report

That makes life a lot easier. Thanks so much for your help, greatly appreciated.
Ask a question