You can use conditional formatting...

1) Select C4

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=(C4<B4)

Note that if you don't want C4 highlighted when it's empty, use the
following formula instead...

=(C4<"")*(C4<B4)

4) Choose your formatting

5) Click Ok

Hope this helps!

In article ,
"Dave803" wrote:

Hi

I have a spread sheet in which I want to highlight certain cells
automattically.
ie

B4 = 39
C4 = 38
how do I get Excel to highlight the figure in C4 if it is less than B4,
someone said it was something to do with exceptions but I cannot find any
details on that.
Hope someone can help

Dave