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