Thread: Conditional Formatting

Heres a questions.

Is there any way of incraseing the conditional formatting. I know you can have only three, but belive it or not, i need 4.

Im highlighting a row depending on an outcome from a certain cell, but i have 4 conditions.

Any help plz....

I think i need 4 plus default, ie if none of the 4 conditions are meet then the row stays white, its if any of the four conditions are meet then the row turns yellow.

Question, is it possiable to put more than one condition in a condition. That sound confussing but is 1 condition is as below

=L120="False"

could you put

=L120="Yes","No"

or something like that...???

That works great, the OR statement worked.

Here another question, Is it possiable to copy the conditional formating from my edited row and paste it to the other rows with out affecting the formula and data that have already been inputted...??

Thanks ED

Your a master, working like clock work, well that until somebody wants me to change the sheet and extra stuff, then it will probably fall to pieces again.

In the And or OR statments can you have more than two conditions...??