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
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
two values to find on the same cell
jutulu -
jutulu -

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

26 responses