Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting using Formula
Hello,
I am trying to create a formula within excel 2003 which will format a cell depending on whether the criteria is met. So for example, I want to use cell a4, that contains a date value to calculate length in months using todays date then dependent on that outcome, turn cell a10 red, if the length of months is 0-2 and value of cell a10 is more than 240. if length is 3 months then turn red if more than 200 and if length is greater than 3 months, turn red if more than 190 and so on.. Im thinking this requires some VB scripting to work? There could be an easier way to do this. Thanks, WA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with a formula or conditional formatting | Excel Worksheet Functions | |||
what formula do I use for conditional formatting? | Excel Worksheet Functions | |||
Conditional formatting is set with a formula, but now I need to ch | Excel Discussion (Misc queries) | |||
Conditional formatting formula | Excel Worksheet Functions | |||
conditional formatting with FORMULA... Please HELP! | Excel Discussion (Misc queries) |