Mar 04 2022 10:22 AM
I am creating a classmate roster including both active and deceased members. I want to create a conditional format for the entire sheet where all cells for a deceased member are in a different font color based on the text value in a cell.
Mar 04 2022 10:36 AM
=$A2="former"
Based on the text value in a cell in column A you could apply above rule for conditional formatting.
=$2:$1048576
This is the range in order to apply the format to the entire sheet.