Forum Discussion
Conditional Format calculated across relative references, applied to an absolute reference
Hi there 😊 I would like to place some conditional formatting on some helper text to highlight it when a user has made an error. I have created a dummy file to replicate what I am trying to do - a co...
SergeiBaklan That is brilliant, thank you. I only learned of the "*" operator in the past few months when my employer finally upgraded to Office 365 - but I learned it in conjunction with the FILTER function as part of the syntax I needed at the time (and have used extensively since). I had no idea it could be used outside of FILTER until now 😳 It will come in handy for me with type of work I tend to do in Excel.
