[Solved] Conditional Formatting - Ignore Blank Cells

Talk about anything at all....

[Solved] Conditional Formatting - Ignore Blank Cells

Postby AndrewD » Thu Jan 25, 2018 8:33 pm

I am making a tracker that will track the status of items that have been ordered for work. Currently one of my formatting rules reads as =$I2<>$C2, but I am trying to edit it so that it will ignore blank cells in column I and will not change their formatting.

I have found a previous post with the example =AND(NOT(ISBLANK($I2<>$C2))), but this didn't seem to work for me.

Disclaimer: I am still rather new to the complex workings of Excel and don't know much about conditional formatting or macros. I'm mainly relying on examples I have found on forums.
Last edited by AndrewD on Thu Jan 25, 2018 10:10 pm, edited 1 time in total.
Office 2013, Windows 10 Enterprise
AndrewD
 
Posts: 3
Joined: Thu Jan 25, 2018 8:21 pm

Re: Conditional Formatting - Ignore Blank Cells

Postby RoryOF » Thu Jan 25, 2018 8:41 pm

I can't help with your problem, but before anyone else points it out, if you are using OpenOffice, then you are using Calc, which is in many ways functionally equivalent to Microsoft Excel, but is not a clone of it, so there are differences in the codes used for programming it.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25957
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Conditional Formatting - Ignore Blank Cells

Postby FJCC » Thu Jan 25, 2018 8:58 pm

I am not sure of the condition you are trying to match. Does this work for you?
Code: Select all   Expand viewCollapse view
=AND(NOT(ISBLANK($I2)); $I2<>$C2)
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 6307
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Conditional Formatting - Ignore Blank Cells

Postby AndrewD » Thu Jan 25, 2018 9:34 pm

FJCC wrote:I am not sure of the condition you are trying to match. Does this work for you?
Code: Select all   Expand viewCollapse view
=AND(NOT(ISBLANK($I2)); $I2<>$C2)


That code didn't seem to work at all, it just gave me an error saying that Excel doesn't recognize the formula. As I previously mentioned, I am still very new to this and don't have a grasp on all of the functions yet. Here is a screenshot of what I'm referring to. The I column is showing red for blank cells, I'm trying to make it so that it only shows red if the value entered into the cell does not match its counterpart in column C.

Image

My computer is acting strange, so if the image doesn't show up just let me know.
Office 2013, Windows 10 Enterprise
AndrewD
 
Posts: 3
Joined: Thu Jan 25, 2018 8:21 pm

Re: Conditional Formatting - Ignore Blank Cells

Postby FJCC » Thu Jan 25, 2018 9:42 pm

Sorry, I didn't read your signature. You are using Excel and I haven't used that in years. This forum supports OpenOffice and LibreOffice, not Microsoft Excel. You will likely get better answers on a Microsoft Office forum. The one change to my formula that I can suggest is to replace the semicolon with a comma
Code: Select all   Expand viewCollapse view
=AND(NOT(ISBLANK($I2)), $I2<>$C2)
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 6307
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Conditional Formatting - Ignore Blank Cells

Postby AndrewD » Thu Jan 25, 2018 10:00 pm

Thank you for the help, I see the confusion now.
Office 2013, Windows 10 Enterprise
AndrewD
 
Posts: 3
Joined: Thu Jan 25, 2018 8:21 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests