Forum Discussion
Format Conditioning a Cell's input to determine the color of the row in a table.
I have a table, and am trying to make a format condition so that if I put a certain input into a certain cell, it will make everything in that row green with black letters. Any ideas?
Hello ZacharyWalter,
If the input is a string, then that could be:
=$A1="abc"
If the input is a number, then that could be:
=$A1=1
Then format the fill and font as you wish and apply the conditional format to the appropriate row.