Excel Formatting
Closed
JJones
-
Feb 24, 2010 at 09:43 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 11:09 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 11:09 PM
Related:
- Excel Formatting
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- Clear formatting in excel - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 24, 2010 at 11:09 PM
Feb 24, 2010 at 11:09 PM
Yes it is possible. For that you have to use conditional formatting
Lets say that you want to change color based of value in column B'
1. Select the target rows (or entire sheet)
2. Go to conditional formatting
3. enter this formula
=IF(AND($B1>=0, $B1<=99,$B1<>""),TRUE)
4. Go to format and change the format as you wish
Here $b1 is based on presumption that the first row in your selection is row 1. If its is not, change it to the first row of selection like $B5 etc
Lets say that you want to change color based of value in column B'
1. Select the target rows (or entire sheet)
2. Go to conditional formatting
3. enter this formula
=IF(AND($B1>=0, $B1<=99,$B1<>""),TRUE)
4. Go to format and change the format as you wish
Here $b1 is based on presumption that the first row in your selection is row 1. If its is not, change it to the first row of selection like $B5 etc
