| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i change the format of a cell based on the condition of another cell in same row?
For example:
ED -1 SHORT $98.13 $98.12 ZB -1 SHORT 107 28/32 107 27/32 If A1 ="ED", then id like D1 & E1 to be formatted as currency If A1 ="ZB" then id like D1 & E1 to be formatted as fraction 1/32 etc Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i change the format of a cell based on the condition of another cell in same row?
Believe you would need to run a macro to reformat the cells. Place your
code in the change event or perhaps the calculate event. Conditional formatting doesn't support changing this aspect of the format Normal cell formatting doesn't support conditions based on another cell. -- Regards, Tom Ogilvy "scott23" wrote in message om... For example: ED -1 SHORT $98.13 $98.12 ZB -1 SHORT 107 28/32 107 27/32 If A1 ="ED", then id like D1 & E1 to be formatted as currency If A1 ="ZB" then id like D1 & E1 to be formatted as fraction 1/32 etc Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to change the cell format (color) based on a calc | Excel Discussion (Misc queries) | |||
| Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
| Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
| I want to fill the cell color based upon the other cell condition | Excel Discussion (Misc queries) | |||
| How do I change the format of a cell based on what I input? | Excel Worksheet Functions | |||
Linear Mode
