Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0

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.

Excel conditional formatting
Excel date format dd.mm.yyyy - Guide
Marksheet format in excel - Guide
Clear formatting in excel - Guide
Number to words in excel - Guide
Excel apk for pc - Download - Spreadsheets

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 4, 2010 at 06:11 PM

apply format where ?
could you explain a bit more

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.

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

G
Jun 7, 2010 at 11:05 AM

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

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Date formatting in dd/mm/yyyy

Similar discussions

Subscribe To Our Newsletter!