Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formating
Hi!
I use Excel 2007, I need some help: 1-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting (changing color of cell, color of border) to C3. 2-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting to display words €˜greater, €˜less or €˜equal to D3. 3-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting to set only icons to E3, I mean the three icons which represent €˜greater, €˜less or €˜equal. I want to display only icons without values in the cell. Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formating
1 can be done using 3 Formula is: conditions each with a formatted color.
Condition1Formula is: =B30 Condition2Formula is: =B3<0 Condition3Formula is: =B3=0 2 cannot be done using CF............must be in-cell formula. =IF(B3=0,"equal",IF(B30,"greater","less")) entered in D3 3 I think this can only be done on the selected cell(E3) when E3 contains a value. Gord Dibben MS Excel MVP On Tue, 25 Aug 2009 14:59:48 -0700, Walley wrote: Hi! I use Excel 2007, I need some help: 1-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting (changing color of cell, color of border) to C3. 2-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting to display words ‘greater’, ‘less’ or ‘equal’ to D3. 3-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting to set only icons to E3, I mean the three icons which represent ‘greater’, ‘less’ or ‘equal’. I want to display only icons without values in the cell. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating | Excel Discussion (Misc queries) | |||
conditional formating | New Users to Excel | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) |