I need to apply a conditional formating to a spreadsheet to make cells blank if the text is equal to "Off"
I fteh Text is something other then Off then I want the text to show.
how would I use the If this then that formula
=if("Off"," ","")
Thank you
Last edited by nsmjc; 01-05-2020 at 10:20 AM. Reason: Solved
Hi
Use the CF 'Formula' option
Formula:
Please Login or Register to view this content.
and set the CF for the text to the same colour as the sheet background, i.e. white unless you've changed it.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I am not quite clear hwta you mean by conditional formatting here, as you have attempted an IF statement.
If it's a formula you need, then maybe this in B1 for example:
=IF(A1="Off","","Text you wish to show")
If it's a cse of making A1 appear empty if it contains "Off", then the CF rule would be this:
=A1="Off"
and the text formatting would be white.
If you can't work it out from this, attach a sample workbook,
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I need to apply this to all the cells and I need a blank as the rows alternate color so changing it to white will not work. I thought putting it into a conditional format for the entire sheet would work best.
I just cannot figure out how to make all the cells with the word off in them go blank.
As I said, attach a sample workbook.
Sorry I Thought I did here is the sample I need all the Off to show Blank
It gets its data from a form. So if a box is not checked it is Off we need to hid all the Off so we can easier see the Yes and No
Since you have a table, do as Richard suggests
In CF
Cell value = "Off"
-- White font -- White background.
See attached
formula-for-conditional-formatting-a-cell-to-blank-based-on-value-force-response-results-master.xlsx
Life's a spreadsheet, Excel!
Say thanks, Click *
Yes but that takes away from the alternating row colors and is not visually complete is there a way to do this while keeping the row colors intact.
With cell A2 selected, set the following TWO rules:
=AND(ISODD(ROW()),A2="Off") - set text to white
=AND(ISEVEN(ROW()),A2="Off") - set text to blue to match the blue rows
Apply both rules to: =$A$2:$P$22 (or extend to suit)
That worked thank you
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks