Cell formating

Closed
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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 reply

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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