Previous Topic Next Topic

Change color of cells in Excel based on data in other cells

Closed
brohera - Jun 20, 2016 at 04:43 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 20, 2016 at 04:58 PM
Hello,
I have a question for Excel 2010 Conditional Formatting.

How can I change the color of a cell to red if the value in another cell is different. e.g if cell A1 is $0 and cell AF is $5 then change the value of cell A1 to red color. I have Excel 2010

Thanks in advance


1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 20, 2016 at 04:58 PM
Try to use:

Select A1

Conditional Formating:
Formula:
=AND(A1=0,AF1=5)

Choose the color RED for FONT COLOR.

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

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

20 responses
Excel function question
1234ah -
ac3mark -

3 responses