Format row based on cell value

Copper Contributor

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.  

1 Reply

@LarryB55 

=$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.