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

Question

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


Configuration: Windows 8 / Internet Explorer 10.0

Mazzaropi · Answer

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

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

1 response

Similar discussions

Subscribe To Our Newsletter!