Conditional Formatting
I am having troubles setting up the conditional formating for a
worksheet. I have been trying to set up a format that highlights the cell ONLY when the value is greater than one, but it isn't working. The formating not only highlights the cell when the value is greater than 1, it also highlights the cell when the value is " ", is there any way to stop this from happening? |
Conditional Formatting
In the Conditional Formatting dialog, select 'Formula Is' instead of 'Cell
Value Is'. Then, in the adjacent textbox, enter =AND(ISNUMBER(B2),B21) Set the formatting you want, and click OK to close the Conditional Formatting dialog. Hope this helps, Hutch "mastermind" wrote: I am having troubles setting up the conditional formating for a worksheet. I have been trying to set up a format that highlights the cell ONLY when the value is greater than one, but it isn't working. The formating not only highlights the cell when the value is greater than 1, it also highlights the cell when the value is " ", is there any way to stop this from happening? |
All times are GMT +1. The time now is 08:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com