Cell formating

Closed
iliyatz - Oct 8, 2015 at 11:30 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2015 at 01:37 PM
Hello,

I have excel sheet that contains 1000 rows of customer and i need to change color in one cell based on anther cel in same row ,this i solved but now i want to apllay tis rule to each row ,each row with it's own cell .

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 8, 2015 at 01:37 PM
iliyatz, Good afternoon.

At Conditional Format Menu after defined the formula will apeear:
"APPLY TO:"
in your case will appears only the cell you select before.
eg.: $D$4
Now UPDATE this range to your desired range.
eg.: $D$4:$D$20

Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0