Simple question, thanks in advance

[smittycft99]

How do I;

If the value in A1<8 then A2 cell is red, otherwise A2 is green.

Thanks a million

 

[Brian from Maui]

Using Conditional formatting

Formula is =countif(a1,"<8")Pattern red
Cell value is greater than 8 Pattern green

However, with the above the cell will either be red or green all the time.

 

[smittycft99]

I went into conditional formating but I didn't see how to specify a color

 

[Nimrod]

for the formula use the "cell value is" in the drop down . To choose colors select the format button in the conditional format window then the font tab and color drop down.
For background color choose the pattern tab.

 

[smittycft99]

thank you!!!

 

[Yogi Anand]

On 2002-05-09 11:40, smittycft99 wrote:
How do I;

If the value in A1<8 then A2 cell is red, otherwise A2 is green.

Thanks a million

Hi smittycft99 and Brian:

The CONDITIONAL format should be ...
condition 1 ... formula is =A1<8 ... Pttern -- color 'red'
condition 2 ... formula is =A1>=8 ... Pattern -- color 'green

by the way Brian -- for the conditional formatting here we are not counting any thing so no need for COUNT...

Hope This Helps!

 

[Brian from Maui]

Yogi,

Mahalo!



Brian