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.

Related:

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
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 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
0
G
Jun 7, 2010 at 11:05 AM
That makes life a lot easier. Thanks so much for your help, greatly appreciated.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses