Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I conditionally hide or display data in a cell?
I would like to display a cell dependent on the value of another cell.
If the value in a cell exceeds 10% of the value in another cell, I would like to display a warning message in red. I don't want to see the message at all if the value in the original cell does not exceed 10%. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I conditionally hide or display data in a cell?
You would need a third cell for a message
You could colour the target cell using Format | Conditional Formatting Something like--- Formula Is A10.1*B1 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mrsphyl" wrote in message ... I would like to display a cell dependent on the value of another cell. If the value in a cell exceeds 10% of the value in another cell, I would like to display a warning message in red. I don't want to see the message at all if the value in the original cell does not exceed 10%. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I conditionally hide or display data in a cell?
On Jun 12, 5:21 pm, "Bernard Liengme"
wrote: You would need a third cell for a message You could colour the target cell using Format | Conditional Formatting Something like--- Formula Is A10.1*B1 best wishes -- Bernard V Liengme Microsoft Excel MVPhttp://people.stfx.ca/bliengme remove caps from email "mrsphyl" wrote in message ... I would like to display a cell dependent on the value of another cell. If the value in a cell exceeds 10% of the value in another cell, I would like to display a warning message in red. I don't want to see the message at all if the value in the original cell does not exceed 10%. Just to add: Type your warning message in the 3rd cell. Color the font white to hide it normally. Then do a conditional format of red font with the formula Bernard gave you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
Way to conditionally hide rows? | Excel Worksheet Functions | |||
a way to conditionally hide tabs in a range | Excel Discussion (Misc queries) | |||
Is there a way to conditionally hide a row? | Excel Discussion (Misc queries) | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) |