Conditional Formatting
Hi,
Select all the rows to which this applies then
Format|Conditional format - Formula is
Enter the formula
=$C1="New"
Pick a colour - Ok
adjust the 1 in $C1 to the row number of the first row this applies to.
Mike
"Lal" wrote:
How can I conditional format for the whole row? In a list if column C shows
"new" for a new client, how can I ensure that the whole row is automatically
turned blue with white writing(for example)?
|