Hi everybody,
I am currently creating a spreadsheet which will work out which shift different teams will be on a given date. Everything is working on it apart from the conditional formatting for the rows.
I am using the conditional formatting formulae INDIRECT("Q"&ROW())="1" so it should read column Q and if the value is "1" it should highlight it in Bold.
This is working great on all the rows apart from the first row which has left me a bit puzzled. One of the cells on the first row (P3) uses the VLOOKUP, could this be the cause?
Does anyone have any ideas what could be causing the issue or know a different way to tackle the problem I'm having?
Thank you,
S
Bookmarks