Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell blank color "red"
Hello from Steve Dee
In Column U:U I have the below Formula ( Office 2007 ) =IF(+S108-T108<0,"",+S108-T108) I would like please if the cell is blank the cell to change to color "Red" I thankyou |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell blank color "red"
Select etiher the whole column, or just the cells with your formula. Go to
Format-condition format. Set condition to if cell value = "" Click format, and pick the red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steved" wrote: Hello from Steve Dee In Column U:U I have the below Formula ( Office 2007 ) =IF(+S108-T108<0,"",+S108-T108) I would like please if the cell is blank the cell to change to color "Red" I thankyou |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell blank color "red"
And remember that you don't need the + in your formula.
=IF(+S108-T108<0,"",+S108-T108) can be changed to =IF(S108-T108<0,"",S108-T108) -- David Biddulph "Luke M" wrote in message ... Select etiher the whole column, or just the cells with your formula. Go to Format-condition format. Set condition to if cell value = "" Click format, and pick the red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steved" wrote: Hello from Steve Dee In Column U:U I have the below Formula ( Office 2007 ) =IF(+S108-T108<0,"",+S108-T108) I would like please if the cell is blank the cell to change to color "Red" I thankyou |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell blank color "red"
Hello from Steved
Thankyou for your reply Question please and that is Can I apply Set condition to if cell value = "" only if the cell has a formula in it, as at the moment it does it to all blank cells. I thankyou. "Luke M" wrote: Select etiher the whole column, or just the cells with your formula. Go to Format-condition format. Set condition to if cell value = "" Click format, and pick the red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steved" wrote: Hello from Steve Dee In Column U:U I have the below Formula ( Office 2007 ) =IF(+S108-T108<0,"",+S108-T108) I would like please if the cell is blank the cell to change to color "Red" I thankyou |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell blank color "red"
Hi,
To conditionally format your cell(s): In 2003: 1. Select the cells you want to format 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =A1="" 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =A1="" 5. Click the Format button and choose a format. 6. Click OK twice -- If this helps, please click the Yes button Cheers, Shane Devenshire "Steved" wrote: Hello from Steved Thankyou for your reply Question please and that is Can I apply Set condition to if cell value = "" only if the cell has a formula in it, as at the moment it does it to all blank cells. I thankyou. "Luke M" wrote: Select etiher the whole column, or just the cells with your formula. Go to Format-condition format. Set condition to if cell value = "" Click format, and pick the red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steved" wrote: Hello from Steve Dee In Column U:U I have the below Formula ( Office 2007 ) =IF(+S108-T108<0,"",+S108-T108) I would like please if the cell is blank the cell to change to color "Red" I thankyou |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell blank color "red"
Thankyou.
"Shane Devenshire" wrote: Hi, To conditionally format your cell(s): In 2003: 1. Select the cells you want to format 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =A1="" 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =A1="" 5. Click the Format button and choose a format. 6. Click OK twice -- If this helps, please click the Yes button Cheers, Shane Devenshire "Steved" wrote: Hello from Steved Thankyou for your reply Question please and that is Can I apply Set condition to if cell value = "" only if the cell has a formula in it, as at the moment it does it to all blank cells. I thankyou. "Luke M" wrote: Select etiher the whole column, or just the cells with your formula. Go to Format-condition format. Set condition to if cell value = "" Click format, and pick the red pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steved" wrote: Hello from Steve Dee In Column U:U I have the below Formula ( Office 2007 ) =IF(+S108-T108<0,"",+S108-T108) I would like please if the cell is blank the cell to change to color "Red" I thankyou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to find non-blank cell values "hidden" under merged regions? | Excel Discussion (Misc queries) | |||
If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |