Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formatting a cell with a function (IF statement)
I'm wondering if it is possible to format a cell say, color it by using an IF
statement, perhaps using a macro?. My if statement is: =IF(A11400,"X"," "), but instead of the "X" I would like the cell to turn red. Am I dreaming of impossibilities? -- Cheerio |
#2
|
|||
|
|||
Highlight cell A1.........then do Format ConditionalFormatting
CellValueIs Greater than 1400 Format PatternsTab choose RED OK OK................ Vaya con Dios, Chuck, CABGx3 "Dreaming" wrote in message ... I'm wondering if it is possible to format a cell say, color it by using an IF statement, perhaps using a macro?. My if statement is: =IF(A11400,"X"," "), but instead of the "X" I would like the cell to turn red. Am I dreaming of impossibilities? -- Cheerio |
#3
|
|||
|
|||
Thank you, will try!
-- Cheerio "CLR" wrote: Highlight cell A1.........then do Format ConditionalFormatting CellValueIs Greater than 1400 Format PatternsTab choose RED OK OK................ Vaya con Dios, Chuck, CABGx3 "Dreaming" wrote in message ... I'm wondering if it is possible to format a cell say, color it by using an IF statement, perhaps using a macro?. My if statement is: =IF(A11400,"X"," "), but instead of the "X" I would like the cell to turn red. Am I dreaming of impossibilities? -- Cheerio |
#4
|
|||
|
|||
My Bad..........sorry.........I didn't read closely enough..........Biff is
right, you need to use the INDIRECT statement that he suggested to work between sheets...........or, you could link Sheet1!A1 into Sheet2 and use it from there.......... Vaya con Dios, Chuck, CABGx3 "Dreaming" wrote in message ... Thank you, will try! -- Cheerio "CLR" wrote: Highlight cell A1.........then do Format ConditionalFormatting CellValueIs Greater than 1400 Format PatternsTab choose RED OK OK................ Vaya con Dios, Chuck, CABGx3 "Dreaming" wrote in message ... I'm wondering if it is possible to format a cell say, color it by using an IF statement, perhaps using a macro?. My if statement is: =IF(A11400,"X"," "), but instead of the "X" I would like the cell to turn red. Am I dreaming of impossibilities? -- Cheerio |
Reply |
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 |