making a cell a certain font color based on condition

R

Robin

How do i make a macro or piece of code which will change the font color of a
cell if the number is a certain value? For example, if the value of the
number in a certain cell is 1,3,5,7 make the cell font red otherwise make it
black.
 
S

Stefi

Why don't you apply a simple Conditional format without any macro?

Regards,
Stefi

„Robin†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the font color based on the value of the cell 9
Color rows based on a cell value 2
Remove Hyperlinks Without Changing background shading 14
Change the font color based on value of cell 1
macro to color all text red in worksheet if within certain date 3
Selection.AutoFill Destination:=Range 0
Locate and change font color 1
changing the color of a cell acording to its value 4

Top