Forum Discussion
excel conditional formatting
I'm trying to highlight a range of cells in a row when data is entered in a particular cell in that row. For example: Select A1:D1 This is the range I want to change color Select "Condition...
Actually, my solution is not the best, because if I enter 0, it doesn't highlight, Therefore I need to enter a very small number such as .00001 and if the numeric format is set to display 2 decimals it displays as 0.00. and high-lights as it should. Could there be another approach to make it high-light when I enter zero?
- No that doesn't work. It makes all cells immediately to format to the selected color.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?