Hi,
I have the following function that finds the current fiscal week (FW)& highlights the row.
=$J5=$J$3 which the function is in the Conditional Formatting Rules Manager & using the following rule type:
Use a Formula to determine which cells to format
$J5 - Represents the first cell in the FW column
$J$ - Represents the current FW, in this instance FW 20
The above function works well to highlight the row or horizontally. Now, I would like to take a similar function that highlights the respective column or vertically.
How would I modify?
Thanks
Bookmarks