I haven't done this for many years and the current excel does not operate as I seem to remember.
I want to highlight a cell if another cell has an entry. I have tried =D6 <> "" and =D6 <> () but neither is accepted or the application doesn't happen.
Any help appreciated.
ND
Got a credit card? use our Credit Card & Finance Calculators
Thanks to gpadsa,Steffers0,lansdown,Wasron,jfgw, for Donating to support the site
Excel Conditional Formatting
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10032 times
Re: Excel Conditional Formatting
NilDesper wrote:
I haven't done this for many years and the current excel does not operate as I seem to remember.
I want to highlight a cell if another cell has an entry. I have tried =D6 <> "" and =D6 <> () but neither is accepted or the application doesn't happen.
Try -
=NOT(ISBLANK($B3))
where $B3 is the cell that might be blank, or might have something in it.
Tested and working on Office 2007.
Cheers,
Itsallaguess
-
- Lemon Quarter
- Posts: 1429
- Joined: November 5th, 2016, 10:53 am
- Has thanked: 356 times
- Been thanked: 500 times
Re: Excel Conditional Formatting
NilDesper wrote:I haven't done this for many years and the current excel does not operate as I seem to remember.
I want to highlight a cell if another cell has an entry. I have tried =D6 <> "" and =D6 <> () but neither is accepted or the application doesn't happen.
Any help appreciated.
ND
Or, if you want to do something with the information:
Something of the form: =IF(B7<>"",<action if B7 is not blank>,<action if B7 is blank>) should do the trick.
HTH,
Watis
Return to “Technology - Computers, TV, Phones etc.”
Who is online
Users browsing this forum: Bing [Bot] and 2 guests