LinkBack URL
About LinkBacks
excel.jpg
Hi!
I've trying to set two conditions to format a simple cell. Why is this not working?
Best regards
excel.jpg
Hi!
I've trying to set two conditions to format a simple cell. Why is this not working?
Best regards
Last edited by AliGW; 06-24-2019 at 03:09 AM.
On D1 CF
=AND(A1=1,B1=2)
Picture.JPG
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Why does it keep giving me an error message while writing the exact code?
excel1.jpg
Don't give space in between the formulaOriginally Posted by wizzan1
There are no spaces between the formula
Open the attached file and see how it shows for you.
For me it showed =AND(A1=1;B1=2) instead of =AND(A1=1,B1=2)
It worked with a ; instead of ,
Thanks alot!
Glad you fixed it
Any how you can change the setting.
To change the setting follow the below link.
https://www.excel-exercise.com/comma...excel-formula/
To mark a thread as solved, please select Thread Tools from the menu link above and mark this thread as SOLVED. Please do not edit the thread title. I have corrected this for you this time.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks