|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
04-03-2006, 11:51 AM
|
|||
|
|||
help me with ifs please
i have a spreadsheet im working on. i have a column of invoice due dates. It has a conditional format that says "cell value is less than =today()" it turns the font red. i need to make it turn back once there is anything typed into another column saying it was paid.
Im having trouble with this and im new to excel. 
|
|
#2
10-05-2006, 07:43 PM
|
|||
|
|||
|
add 2 columns
such as:
Column:E--Paid G--if(and(blank(e1),a<today()),1,0) conditional formatting ...
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
