How to use multiple conditions to color 1 cell?

Ok,

What I am trying to do is this. I have many columns but I want to look at 3 columns:

A B C

in column A, I want to look for the word "standard"
in column B, I want to look for the number "3"
in column C, i want to find any number greater than or equal to "3"

The end result would cell fill with the color *red* the cell in column C (if all three are found)

Not sure if a formula will work here or VB scripting (macro)

please help

Thanks!

Select all 3 column and invoke conditional formatting.

Select Formula Is (in 2003-) or Use formula to determine which cells to format (2007+) and enter

=AND($A1="Standard",$B1=3,$C1>=3)

where A1:C1 is top most row in your selection.

Then click Format and choose appropriate pattern/fill.

ok this does seem to work MANUALLY, however I need this in the personal macro book to use as the file I open changes daily

The column with data I am looking for will be in the same columns.... I will be using multiple conditional formatting and this does not look promising with the first macro condition failing....


So for the macro it shows:

Please Login or Register  to view this content.

It is doing its own weird random red coloring, such as putting a cell red that doesnt meet criteria... doesnt make sense...

ideas?

I didn't try to diagnose your code but I don't see why you need a macro to do this. What is it that changes every day? If the data changes, the conditional formatting stays in place. Does something happen to wipe out the formatting?

As for the code, if the data is in C2:C8 then your formula needs to correspond:

Please Login or Register  to view this content.