Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting the Cell color directly in an IF formula
Hi all,
I have the problem to format a cell directly within an IF Formula. I think I have seen once something similar to IF (A1<10; [red]ok; [yellow]NOK), so without using a conditional formatting. Can any of You help me or let me know I am crazy? thank You in advance Daniel |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting the Cell color directly in an IF formula
As far as i know you can't use that notation to colour a cell in a an IF formula, you would have to use conditional formatting or use code for a SELECT CASE statement in the worksheet change or calculation event. daniel ron;230774 Wrote: Hi all, I have the problem to format a cell directly within an IF Formula. I think I have seen once something similar to IF (A1<10; [red]ok; [yellow]NOK), so without using a conditional formatting. Can any of You help me or let me know I am crazy? thank You in advance Daniel -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64489 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting the Cell color directly in an IF formula
Hi,
You saw correctly. Here is an example: [<10][Red]"OK";[Yellow]"NOK" Select the cells to format. To set this up choose Format, Cells, Number tab, Custom and enter the above on the Type line. -- If this helps, please click the Yes button Cheers, Shane Devenshire "daniel ron" wrote: Hi all, I have the problem to format a cell directly within an IF Formula. I think I have seen once something similar to IF (A1<10; [red]ok; [yellow]NOK), so without using a conditional formatting. Can any of You help me or let me know I am crazy? thank You in advance Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color formatting in cell $An | Excel Discussion (Misc queries) | |||
Is conditional formatting or formula possible by cell color? | Excel Worksheet Functions | |||
Conditional Formatting and Cell Color | Excel Worksheet Functions | |||
formula equals cell directly above | Excel Discussion (Misc queries) | |||
Formatting a cell for color that has a formula also | Excel Discussion (Misc queries) |