QUESTION
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.
REPLIES
@SkipVought
Select ALL the DATA in columns B & C.
Open CF > New rule > Use a formula…
…and enter the formula…
=$B1=$A$1
Hit the Format… Button
Select the Fill TAB and select the appropriate color.
SOURCE
https://www.eng-tips.com/viewthread.cfm?qid=401911
Above is a snippet.