Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response