Hi
try the following:
- select all cells in column C for which you want to apply your
conditional format
- goto 'contional format' and enter the following formulas
a) =C1F1 - choose format 'red'
b) =C1<F1 - choose format 'green'

change C1 to the top cell of your column selection (if it does not
start with C1)

Frank

If column c column F then font = red
If column c < column F then pattern = green
If column c = column F then no format

I need to apply this to a range of cells in column c.

THanks


---
Message posted from http://www.ExcelForum.com/