Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |