• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting

cmf735

Member
Sorry, I'm unable to attach my spreadsheet because it's too large so I'm attaching a screenshot. I'm trying to find a way to highlight cells in Column B and C that are the same date in column A. I'm also trying to highlight cells in Column C that are equal to 1/2/1900. I don't want to use highlight duplicate values because every cell will be highlighted. I need to highlight the specific dates that are duplicates of column A in the same row.
75387
 

vletm

Excel Ninja
cmf735
You could send above selection as a sample with an Excel-file.
... and if Your file is 'too large' ... then conditional formatting would make Your file as well as bigger.
 

Marcilio

New Member
cmf735, Good morning.

Try to do this:

a) Highlight cells in Column B and C that are the same date in column A

Select B2:C100
...> Conditional Formatting
...> New Rule
...> Select: Use a formula to determine wich cells to format
...> Rule formula box:

=AND($A2=$B2;$A2=$C2)

...> Click Format button ...> Choose Fill color as desired
...> OK

b)
Highlight cells in Column C that are equal to 1/2/1900

Select C2:C100
...> Conditional Formatting
...> New Rule
...> Select: Use a formula to determine wich cells to format
...> Rule formula box:

=C2=--"01/02/1900"

...> Click Format button ...> Choose Fill color as desired
...> OK

Adapt the ranges to your reality.

Please, tell us if it worked as you desire.

I hope it helps.
 

cmf735

Member
I figured out how to highlight Column C using a regular equal to formatting. Still trying to figure how to highlight dates that are the same as column A in the same row.
cmf735, Good morning.

Try to do this:

a) Highlight cells in Column B and C that are the same date in column A

Select B2:C100
...> Conditional Formatting
...> New Rule
...> Select: Use a formula to determine wich cells to format
...> Rule formula box:

=AND($A2=$B2;$A2=$C2)

...> Click Format button ...> Choose Fill color as desired
...> OK

b)
Highlight cells in Column C that are equal to 1/2/1900

Select C2:C100
...> Conditional Formatting
...> New Rule
...> Select: Use a formula to determine wich cells to format
...> Rule formula box:

=C2=--"01/02/1900"

...> Click Format button ...> Choose Fill color as desired
...> OK

Adapt the ranges to your reality.

Please, tell us if it worked as you desire.

I hope it helps.
PERFECT! THANK YOU! That's exactly what I was trying to do with a formula. I kept getting error messages. That worked. Thanks again!
 
Top