Conditional Formatting question in Excel 2

[Kenja824]

Lets say in cell A1 I have =TODAY() to show the current date.
Down column B I have a bunch of dates like a calendar strung out in one column.
Down column C I have the days of the week.

I can get the formatting so that in Column B, whichever date matches today's date, that cell will fill in blue.

However, I would like to conditional format column C so that the day of the week next to the blue cell in Column B will also fill in blue.

Is it possible to get a cell to format based on if a different cell matches an entirely different cell?

Example.... If "B7" = "A1", then "C7" will fill in blue.

 

[SkipVought]

HI,

Select ALL the DATA in columns B & C.

Open CF > New rule > Use a formula...

...and enter the formula...
[tt]
=$B1=$A$1
[/tt]

Hit the Format... Button

Select the Fill TAB and select the appropriate color.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Kenja824]

Thanks SkipVought

Not only did it work, but it actually made some sense as to how it works.

Funny how conditional formatting formulas are done different than regular formulas in cells and they are the same program. lol

 

[SkipVought]

You just need an expression return TRUE or FALSE.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]