Forum Discussion
Format row based on cell value
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 ...
=$A2="former"Based on the text value in a cell in column A you could apply above rule for conditional formatting.
=$2:$1048576This is the range in order to apply the format to the entire sheet.