Conditional Formatting Battleship Style

[LeonardH]

Hello Everyone!

I need a formula to add conditional formatting to change the color of cells based on the value called out in the row so that the contents of each cell can otherwise be edited.

In the example below, the header row is fixed and the contents will not change. The dates in each row of the Forecast column, however, may change. On each row, I would only like the cell highlighted in the column that corresponds with the forecasted date.

Forecast

Jan-21

Feb-21

Mar-21

Apr-21

May-21

Jun-21

Jul-21

Aug-21

Sep-21

Oct-21

Nov-21

Dec-21

Jul-21

Blue​

Aug-21

Blue​

​

May-21

Blue​

Jul-21

Blue​

Jan-21

Blue​

Oct-21

Blue​

Aug-21

Blue​

Perhaps I am overthinking this? I have been known to do that.

Thanks in advance for any help! I really appreciate it!

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Forecast	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21
2	Jul-21							Blue
3	Aug-21								Blue
4	May-21					Blue
5	Jul-21							Blue
6	Jan-21	Blue
7	Oct-21										Blue
8	Aug-21								Blue
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:M8	Expression	=$A2=B$1	text	NO

 

[LeonardH]

How about
...

This worked perfectly, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.