Help, need to make field go red or green

[smoran]

Hi,

I have three fields in total ............. I need to make field 3 g
green IF field 1 AND 2 = value 0. I need to make field 3 go red I
field 1 and 2 = anything but 0.

How do I do this ?

Regards

St

 

[JE McGimpsey]

One way:

Format field 3 as red.

With field 3 selected, choose Format/Conditional formatting and use
dropdowns and textboxes to read

CF1: Formula is =AND(<field1>=0,<field2>=0)
Format1: <patterns>/green

where <field1> and <field2> are your cell references (e.g, A1, B1)