Conditional Formatting question in Excel
Conditional Formatting question in Excel
(OP)
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.
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.





RE: Conditional Formatting question in Excel
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.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Conditional Formatting question in Excel
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
RE: Conditional Formatting question in Excel
Skip,
Just traded in my OLD subtlety...
for a NUance!