Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I change the font color in

Status
Not open for further replies.
cjhepburn

cjhepburn

Technical User
Mar 9, 2001
8
US
How can I change the font color in Excel based on another cell block. For example - I'm trying to change the font color to white if the above cell value is the same. I need to retain the value, I just don't want to see it.
The formula should look like this "=if(F2=F1,text(F2,[white])"
Thanks for any ideas.
c
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
203
EFFEY
EFFEY
navyasree
  • Locked
  • Question
Need to update excel on making changes in visio flowcharts 1
Replies
4
Views
198
Andrzejek
Andrzejek
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
182
ladyck3
ladyck3
Saif_Abc
  • Locked
  • Question
Change the Code in Visual Basic
Replies
2
Views
103
Saif_Abc
Saif_Abc

Part and Inventory Search

Sponsor

Back
Top