Martin has attended:
Excel VBA Intro Intermediate course
Conditional formatting
Is it possible to conditionally format a cell based on seperate criteria?
i.e.
if cell a1 is greater or equal to
RE: conditional formatting
Hi Martin
Yes, it is possible to use conditional formatting to place up to 3 conditions on a cell.
If you go to Format - Conditional Formatting, you will find that underneath where you can set the first conditional format, there will be an Add button at the bottom of the dialogue box, which will allow you to set a second condition, then click Add again to add a third condition.
Can I suggest that