Conditional Formatting?!?!?!?

[Sh0t2bts]

Hi All,


I want to build a worksheet for checking data and the best way I tough I
could do this was by conditional formatting heres what I have

A B C D
Time Code1 Code2 Time2
1 08:30 56 20 08:30
2 00:00 2 0 08:30
3 00:00 0 0 00:00
4 00:00 0 20 08:30

Heres what I would like:-
Formatting Column B
IF Time > 0 and Code 1 = 0 then RED
IF Time = 0 and Code 1 > 0 then RED

How would I do this??

Cheers

Mark

 

[Felipe I]

Mark,

Insert the formulas you need in conditional formatting:

1. Select the area to be formatted (assume B1:B4)
2. Go to Format>conditional formatting
3. Select Formula Is from the combo box.
4. Write the conditional formula:
=OR(AND(A1=0,B1<>0),AND(A1<>0,B1=0))
5. Select the format setting (Format...) button, you can
set font, border, and pattern format.
6. Click OK

Note: the cells you refer to in the formulas should be the
ones needed for the active cell's format. Remember to
delete the $ signs to avoid absolute cell references

 

[immanuel]

In B1, set the following as your custom conditional format for RED:

=OR(AND(A1>0,B1=0),AND(A1=0,B1>0))

/i.