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

Closed
brohera - Jun 20, 2016 at 04:43 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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