change cell color

  • Thread starter Thread starter DHATT
  • Start date Start date
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.
 
Have you tried conditional formatting?

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