Changing font colour depending on cell value

R

RunRonnyRun

Hello, I am hoping someone out there can help me out, I want to change font
colour in columns but the data is in two formats, but both meaning the same
i.e. 10% & 1-10 i would like to be able to turn all data in a column to red
if say under 7% & also turn the same columns data to blue if above say 25%.
This needs to work in a few different columns and with different criteria for
some columns. Any help is appreciated.
 
A

Alan Moseley

Highlight the column then click Format, Conditional Formatting. If you need
more info than this, let me know. The wizard is reasonably self-explanatory.
 

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 colour of cells depending on entry in one cell 9
Copy cell contents depending on font colour 0
Help with conditional formatting in Excel 2010 8
Conditional formatting with vba 3
Conditional Formatting from a group 6
Change the colour of a cell if another named cell is blank 2
Fill cell colour based on input in another cell 2
Conditional formatting - coloured text 8

Top