change cell color

D

DHATT

If-then
Value of one cell equals value of another.If true how can I change the color
of font in the first cell?
example
if A1=A6 then change A1 color to red.
 
Q

Qwerty

Have you tried conditional formatting?

Click cell A1/ format menu/ conditional formatting
If Cell Value Is - equal to - =A6
Format... button/ Font tab/ color
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Tracked changes by multiple people modified to one 0
Match table shading (color) to Visio color/Transparency 1
Fill tringle in a cell with color 1
Address Format changed after Migration 0
Changing row background from external program 0
Change Color of cell 3
need help in creating a formula 1

Top