conditional formats excel

Hi,

write a VBA Function, that checks your conditions and returns either "True" or "False" if the conditions are fullfilled.
Then check this function in your conditions.

I'm not sure, if you can check formulas in conditional formating, If youcan't, then record a makro (doing the cond. formating) and change the code.

If you have any Questions, feel free to contact me.

hope that helps,
Oliver

Hello,
I can't agree (fully) with the asnwer provided. If you want to use the build-in conditional formatting, there are only 3 possibilities for the formatting of the cel and its content. If you use formulas for a condition they can be as complicated as you like, as long as the result is either true or false. However, the formatting of the cel is only possible in three ways. Remember this is font, size, bold, border, background, colour etc etc.
With numbers there is a possibility to use 6 [six] colours for the number by combining "normal"(static) and conditional (dynamic) formatting.
If you want more than 3 formats for the cel and its content, you would have to write yourself an eventprocedure in VBA for the particular cel.