Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with IF statement.
I've got a simple IF statement that generates some text in a cell.
=IF(C8=3,"Material must be removed, due to score of three in Box B","No need to remove") Lets say for arguments sake, that the cell is A15. How can I, A) On logical test 'True' - turn the text in Cell A15 red, but on logical test 'False' keep it black. B) On logical test 'True' - turn the background fill in Cell A15 red, but on logical test 'False' keep it white. (I want either not both - I've not totally decided which I want) SS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with IF statement.
"simon" wrote in
: I've got a simple IF statement that generates some text in a cell. [...] =IF(C8=3,"Material must be removed, due to score of three in Box B","No need to remove") Lets say for arguments sake, that the cell is A15. How can I, A) On logical test 'True' - turn the text in Cell A15 red, but on logical test 'False' keep it black. B) On logical test 'True' - turn the background fill in Cell A15 red, but on logical test 'False' keep it white. (I want either not both - I've not totally decided which I want) SS simon, Conditional formatting will do the trick. Select A15 On the menu: Format - Conditional Formatting Change the first drop down from "Cell Value Is" to "Formula Is" Change the formula to =C8=3 Click the format button to supply the desired format when C8=3 HTH, RP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with IF statement.
You can accomplish this by using a conditional format (short cut keys
ALT O D). Use the "formula is" option, not the "cell value is". be sure to be in the cell or have highlighted the cells you want to conditionally format first, then define the conditional format for that cell or cells. In the blank box type "= True". then choose the format you want for text and cell. Once you have defined a cell with a conditional format, you can copy and paste special format to another cell. Hope this helps. Sean |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with IF statement.
In either case, look at Format=conditional formatting
-- Regards, Tom Ogilvy "simon" wrote in message ... I've got a simple IF statement that generates some text in a cell. =IF(C8=3,"Material must be removed, due to score of three in Box B","No need to remove") Lets say for arguments sake, that the cell is A15. How can I, A) On logical test 'True' - turn the text in Cell A15 red, but on logical test 'False' keep it black. B) On logical test 'True' - turn the background fill in Cell A15 red, but on logical test 'False' keep it white. (I want either not both - I've not totally decided which I want) SS |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with IF statement.
You could use Conditional Formatting. The text in cell A15 changes depending
on the value in C8, so setup the conditional formatting so that Condition 1Formula Is =C8=3 then click the format button and choose either the text color or pattern color (or both - say white on red) "simon" wrote: I've got a simple IF statement that generates some text in a cell. =IF(C8=3,"Material must be removed, due to score of three in Box B","No need to remove") Lets say for arguments sake, that the cell is A15. How can I, A) On logical test 'True' - turn the text in Cell A15 red, but on logical test 'False' keep it black. B) On logical test 'True' - turn the background fill in Cell A15 red, but on logical test 'False' keep it white. (I want either not both - I've not totally decided which I want) SS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup, if statement, maybe an and statement | Excel Discussion (Misc queries) | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |