Conditional Formatting New Rule Formula Construction

[Androexcel]

Hi there,

Thanks for taking the time out to look at this. I have attached a workbook for reference.

Situation:

In C3:C16 I have check boxes in each cell linked to the adjacent cell in Column D

The same applies to cells E3:E16, except they are linked to their respective cells in Column F.

What I need to achieve:

I am trying to figure out how to produce a formula that will fill the cells in Column C/E with either green or red based on the value(TRUE/FALSE) that the check box produces in their adjacent cells in Column D/F.

Thanks a million,

Andreas

[Pete_UK]

If you have been experimenting with CFs on those cells, then remove all previous CF. Then select cells C3:C16, with C3 as the active cell. Click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box:

=D3=FALSE

(or you could use =NOT(D3) )

Click on the Format button then the Fill tab and choose Red, then OK.

While the cells are still highlighted, repeat this using this formula:

=D3=TRUE

(or it could just be =D3)

then choose Green for the Fill.

You can use the Format Painter to copy the format from C3 to E3:E16.

Strictly speaking, you only need one CF if you colour all the cells red to begin with (using the normal colour Fill icon) then set up the CF for the TRUE condition, as CF over-rides any normal formatting.

Hope this helps.

Pete