Previous Topic Next Topic

Excel conditional formatting

Solved/Closed
g - Jun 4, 2010 at 03:14 PM
 G - Jun 7, 2010 at 11:05 AM
Hello,

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

1 reply

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Jun 4, 2010 at 06:11 PM
apply format where ?
could you explain a bit more
0
G
Jun 5, 2010 at 04:45 PM
Hey, sorry wasn't too clear. If date in cell A1 is repeated anywhere in cells B1-B30 then shade A1 a different colour.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Jun 5, 2010 at 05:18 PM
Go to conditional Formatting
Enter this formula
=COUNTIF(B1:B30,"=" & A1)>0

In the conditional format dialogbox, click on format and choose the color
0
G
Jun 7, 2010 at 11:05 AM
That makes life a lot easier. Thanks so much for your help, greatly appreciated.
0