| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting a cell with a function (IF statement)
I have a matrix of values in sheet 1, and the cells in sheet 2 refer to sheet
1 with: =IF('Sheet1'!A11400,"X"," ") but instead of outputting an X in the cell in sheet 2, I would like the cell to turn red if the corresponding cell in sheet 1 is 1400. Help! -- Cheerio |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Hiding a function value in a cell until function used | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| Function making cell really "empty" | Excel Worksheet Functions | |||
Threaded Mode
