conditional formatting

[Guest]

How do I create a conditional formating.
Below is the requirements.

If the value is not in the range or 1 to 8 then the colour of the font or
the cell space will be in red.

 

[Guest]

I assume that you know how to go into conditional formatting and only require
the formula to insert so try this as the formula:-

=OR($A$3<1,$A$3>8)

$A$3 is the cell where you are creating the condtional formatting. It
basically says that if the value of A3 is less than 1 or greater than 8 then
format as per the format setting.

If you need more help on how to go about getting into conditional formatting
and actually doing it then feel free to get back to me but let me know what
version of xl you are using.

Regards,

OssieMac