MAKE FONT GO RED ON CONDITION

[gsc123]

Hi I'm trying to creat a conditon so the font goes read when this sum is actioned

=IF(F172-G172=0,"no","")

the "no" section I would like to make E172 contents read - is this possible?

 

[Lilliabeth]

Have you mentioned what version of Excel? Here are the steps for version 2003:

Select B1:B172
Click the Format menu then choose 'Conditional Formatting'
Use the drop-down to choose 'Formula Is'
Paste in this formula: =H1>G1
Click the little Format button
Go to the Font tab and pick your color
Click OK twice


--Lilliabeth

 

[Gavona]

Just noticed that you have gone from
=G172 - H172 = 0
to
=H172>G172

These are very different conditions. If you need help then by all means explain what you are trying to do. Perhaps with some examples.
Do you want the formatting when the values in the cells are identical,
or when the value in H is greater than the value in G
or when the value in H is greater than or equal to the value in G

Gavin

 

[gsc123]

Cool sorted .. nice help from everyone