Format Find & Replace

Microsoft Excel 2007
February 23, 2010 at 09:48:23
Specs: Macintosh
I am using Excel on an iMac computer. I would simply like to "find" all answers "YES" within a graph of YESses and NOs, and "replace" them with red YESses (format text red).

I can't seem to figure out how to find the "formatting tablet" within the "find and replace" window. Directions would be much appreciated. Thank you!

See More: Format Find & Replace

Report •

February 24, 2010 at 13:51:28

From the Ribbon: Home - Editing - Find & Select - Replace
In the Replace dialog box click on Options>>
You will now see next to the Replace with: box a button labeled Format, Click then select Font and finally color.


Report •
Related Solutions

Ask Question