Thread: In Excel, conditional format (font red) referencing another cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG SteveG is offline
external usenet poster
  
Posts: 1
Default In Excel, conditional format (font red) referencing another cell?

Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Reply With QuoteReply With Quote