Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF then statement+ condiditonal format
Hello,
I am trying to color text white (to essentially hide it) if it meets a certain condition. However, it isn't as simple as if the cell =x. My If statement includes recognizing text. =IF(H12="Independent", color text white, color text black). Is there a way that I can use conditional formatting in this case? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF then statement+ condiditonal format
Mary,
What I do in some of my reports if a formula like =IF(H12="Independent", " ",H12) This would return a blank if H12 is Independent and if H12 is not Independent, it would return the value for whatever is in H12. Hope this helps. Aleisha "mary" wrote: Hello, I am trying to color text white (to essentially hide it) if it meets a certain condition. However, it isn't as simple as if the cell =x. My If statement includes recognizing text. =IF(H12="Independent", color text white, color text black). Is there a way that I can use conditional formatting in this case? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF then statement+ condiditonal format
Thank you. I had tried that but when it left a blank it caused problems with
my other formatting. I thought there was another way, but it looks like I will have to think of something else. "Aleisha Mollen" wrote: Mary, What I do in some of my reports if a formula like =IF(H12="Independent", " ",H12) This would return a blank if H12 is Independent and if H12 is not Independent, it would return the value for whatever is in H12. Hope this helps. Aleisha "mary" wrote: Hello, I am trying to color text white (to essentially hide it) if it meets a certain condition. However, it isn't as simple as if the cell =x. My If statement includes recognizing text. =IF(H12="Independent", color text white, color text black). Is there a way that I can use conditional formatting in this case? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF then statement+ condiditonal format
Yes. In CF, either
Cell Value is/ Equal to: ="Independent" or Formula is: =H12="Independent" and set up your white font -- David Biddulph "mary" wrote in message ... Hello, I am trying to color text white (to essentially hide it) if it meets a certain condition. However, it isn't as simple as if the cell =x. My If statement includes recognizing text. =IF(H12="Independent", color text white, color text black). Is there a way that I can use conditional formatting in this case? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF then statement+ condiditonal format
Thank you! That was what I needed. I didn't know I could write
=H12="Independent" "David Biddulph" wrote: Yes. In CF, either Cell Value is/ Equal to: ="Independent" or Formula is: =H12="Independent" and set up your white font -- David Biddulph "mary" wrote in message ... Hello, I am trying to color text white (to essentially hide it) if it meets a certain condition. However, it isn't as simple as if the cell =x. My If statement includes recognizing text. =IF(H12="Independent", color text white, color text black). Is there a way that I can use conditional formatting in this case? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if statement format cell | Excel Worksheet Functions | |||
Not sure how to format this if statement | Excel Discussion (Misc queries) | |||
How to add date format into if statement? | Excel Worksheet Functions | |||
How to add date format into if statement? | Excel Discussion (Misc queries) | |||
Put an if statement according to cell format | Excel Worksheet Functions |