How do I type in colour without having to change it every cell

J

Jumiclads

I am trying to highlight items in a spread sheet, but i want to type in blue
in different cells without having to keep changing the font colour. Is there
any way of doing this
 
M

Mike

Conditional formatting should do it.

Format the cell with the conditional format of If cell value - is greater
than - ""
and apply your font colour. Use the format painter to copy this into the
other cells.

Mike
 
G

Gord Dibben

Do you have a set order of cells to change to blue font?

Event code could be used to to set the font to blue.

Do these cells have particular values?

Conditional Formatting could be used in this case.


Gord Dibben MS Excel MVP
 
Top