#2
|
||||
|
||||
Hi, grex. If your macro is already calculating the two values, then a) you can probably highlight the proper areas using ordinary conditional formatting, simply having Excel compare the two cells. But b) if your macro has already calculated both values, then maybe it'd be just as easy to highlight the proper areas within the macro, without conditional formatting. Depends on which you think is easier, I guess...and also on whether those calculated values might change later.
I take it you've already tried it one way or another and it isn't working. What did you try, and how did it fail? What error message did you get, for example? |
Tags |
conditional form, macro, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |
Conditional Formatting and/or Macro for Character Insertion? | MonOverArchIng | Word | 2 | 01-11-2013 02:48 AM |
Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
help with conditional formatting | Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |