Hi, I need help coming up with a solution to format cells within the range based on the average of the same range.
Details: If cell in column A=”Text”, then (any cells from columns L:Z in that row that are > the average of L:Z color format red. I have a lot of rows that this formatting would apply to.
Thanks!
Details: If cell in column A=”Text”, then (any cells from columns L:Z in that row that are > the average of L:Z color format red. I have a lot of rows that this formatting would apply to.
Thanks!