Previous Topic Next Topic

Cell formating

Closed
iliyatz - 8 Oct 2015 à 11:30
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 8 Oct 2015 à 13:37
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

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
8 Oct 2015 à 13:37
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

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
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