Hi guys,
Using google sheets.. what is the formula to write:
If Cell J18 is minus 0.0kg, highlight it in red?
Thank you!
Hi guys,
Using google sheets.. what is the formula to write:
If Cell J18 is minus 0.0kg, highlight it in red?
Thank you!
Thanks,
R.
The rule would just be for cell value is less than 0, I believe.
Hi rorya
https://docs.google.com/spreadsheets...it?usp=sharing
Here is my sheet. the rule does not work in cell J18
Conditional formatting is greyed out ...
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.
Hi Ali,
Sorry permission remove. try again please?
Thank you!!
Still no go - sorry!
OK, so other cells are unlocked. You have the correct rule set up, but you have it set to highlight the cell green, not red.
Thanks Ali, I think I just needed to try and get my 'thinking' about the logic/concept right. So i have kept this as green now.. thank you for helping me think about this!
Sometimes it's best to erase all the rules you have set up and start again.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks