Hi
Iam using conditional format for a table where the value is between two numbers then the cell color will get change.
So I have added a rule where the value is between 0 - 30 then the color has to change as grey. Even if the value is 31 also the cell color is not changing.
Please check the screen shot link : https://ibb.co/c10wfa
Need some experts help !!
Thanks in advance
Post a spreadsheet not an image.
Or list the different values for each colour.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Are you using Excel or something else (e.g. Google Sheets)?
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.
Sorry, missed to add these details.
Iam using google spread sheet.
Hi
Below is the spreadsheet link
https://docs.google.com/spreadsheets...it?usp=sharing
If you check H3 and H6, the conditional formatting is not getting applied !!
What went wrong for this both cells. I have tried different way of applying the conditional formatting but, not working.
Please help.
I am moving the thread to the correct section.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks