software

In an Excel Work sheet I want to examine the contents if the Division column
and if the division is HR change the Font color to red else leave the font
color black. AS an example. IF F2 = quot;HRquot;, change the text in F@ to red,
change it to black.

Try this:

Select the cells you want specially formatted
Formatgt;Conditional Formatting
Cell value is equal to =quot;HRquot;
Click the [Format...] button
Set the font color to Red
Click [OK]

Does that help?

***********
Regards,
Ronquot;MKLeisurequot; wrote:

gt; In an Excel Work sheet I want to examine the contents if the Division column
gt; and if the division is HR change the Font color to red else leave the font
gt; color black. AS an example. IF F2 = quot;HRquot;, change the text in F@ to red,
gt; change it to black.

Yes..Thank you

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Select the cells you want specially formatted
gt; Formatgt;Conditional Formatting
gt; Cell value is equal to =quot;HRquot;
gt; Click the [Format...] button
gt; Set the font color to Red
gt; Click [OK]
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;MKLeisurequot; wrote:
gt;
gt; gt; In an Excel Work sheet I want to examine the contents if the Division column
gt; gt; and if the division is HR change the Font color to red else leave the font
gt; gt; color black. AS an example. IF F2 = quot;HRquot;, change the text in F@ to red,
gt; gt; change it to black.