LinkBack URL
About LinkBacks
Hello,
I have an excel sheet with a colom of blanks and 1's.
If one cell of a range is 1 then another cell has to be filled with red.
I tried a conditional formatting function(See file) but it only works with 1 cell of the range.
Tx in advance!
Hello,
I have an excel sheet with a colom of blanks and 1's.
If one cell of a range is 1 then another cell has to be filled with red.
I tried a conditional formatting function(See file) but it only works with 1 cell of the range.
Tx in advance!
CF does work if you get the rule right, which should be this:
=COUNTIF($F$1:$F$11,1)>0
You may have to change commas to semi-colons for your locale.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
That doesn't work unfortunately
Yes, it does. Have a look at my copy.
Ah yeah it works indeed! i don't know why it didn't the first time. Thanks!
Probably because you did not change commas to semi-colons, as I had advised.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks