Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
 767
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
 767
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!