| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i get a TRUE value in a formula to change the color of the.
how do i get a TRUE value in a formula to change the color of the cells that
it references. I have an IF statement that reads as follows: =IF(E100,IF(J10<=0,IF(M10<=0,"Evaluate","Leave")) ) This returns the value of "Evaluate" if my cell number references are zero, and "Leave" if greater then zero. Help!!!! I want to make this a macro that will go through all 15,000 rows of my spreadsheet to evaluate the data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listing data without blank rows | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Can I use TODAY Function in a formula that will not change it the. | Excel Discussion (Misc queries) | |||
Threaded Mode
