Conditional Formatting - If cell in range = value, then highlight all cells to the right of value

[philip_eng]

Hi,

I have a range of cells J3:BK3. Withing that range 1 of the cells will have the text value "C".
I want to conditionally format the row so if a cell in this range = C, then highlight all cells to the right of this cell.

Any idea how to do this?

Phil

 

[AlanY]

try this CF (use formula to determine) in J3 and apply to the range

=COLUMN()>MATCH("C",3:3,0)

 

[philip_eng]

Excellent! Works great

 

[AlanY]

glad that help

 

[philip_eng]

I have another conditional formatting question that I cannot get working. I have dates in row range J3-BK3. I want to highlight the column if the date value falls within this week.

 

[AlanY]

assuming this week is Mon-Sun, try this CF (formula to determine) in J1, and apply to all columns in range

=AND(J$3>=TODAY()-WEEKDAY(TODAY(),3),J$3<=TODAY()-WEEKDAY(TODAY(),3)+6)