Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting troubleshooting
I'm trying to apply conditional formatting to a column of cells. The formula
for these cells is =IF(L8<$B$4,"Late!","Ok") and that is filled down the column. In the conditional formatting section, I've tried to apply the following conditions: Condition 1 Formula Is = ISERROR(reference) [if there's an error, puts #VALUE! in white font] Condition 2 Cell Value Is equal to ="Ok" [if the cell value is Ok, puts Ok in black font] Condition 3 Cell Value Is equal to ="Late!" [if cell value is Late!, puts Late! in red font] I have the formatting setting correctly for each of the conditions, according to the previews of the formats. However, regardless of the value in the cell (the error message of #VALUE!, Ok, or Late!), that value is in white font. Any ideas? I'm not sure if the problem is the order of my conditions (I've switched them but it doesn't seem to help) or my using Cell Value Is instead of Formula Is. Thank you!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting troubleshooting
I have resolved the issue - no need for replies!
"Matt" wrote: I'm trying to apply conditional formatting to a column of cells. The formula for these cells is =IF(L8<$B$4,"Late!","Ok") and that is filled down the column. In the conditional formatting section, I've tried to apply the following conditions: Condition 1 Formula Is = ISERROR(reference) [if there's an error, puts #VALUE! in white font] Condition 2 Cell Value Is equal to ="Ok" [if the cell value is Ok, puts Ok in black font] Condition 3 Cell Value Is equal to ="Late!" [if cell value is Late!, puts Late! in red font] I have the formatting setting correctly for each of the conditions, according to the previews of the formats. However, regardless of the value in the cell (the error message of #VALUE!, Ok, or Late!), that value is in white font. Any ideas? I'm not sure if the problem is the order of my conditions (I've switched them but it doesn't seem to help) or my using Cell Value Is instead of Formula Is. Thank you!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting troubleshooting
Not sure, but what "reference" are you using in that first condition?
--- "Matt" wrote: I'm trying to apply conditional formatting to a column of cells. The formula for these cells is =IF(L8<$B$4,"Late!","Ok") and that is filled down the column. In the conditional formatting section, I've tried to apply the following conditions: Condition 1 Formula Is = ISERROR(reference) [if there's an error, puts #VALUE! in white font] Condition 2 Cell Value Is equal to ="Ok" [if the cell value is Ok, puts Ok in black font] Condition 3 Cell Value Is equal to ="Late!" [if cell value is Late!, puts Late! in red font] I have the formatting setting correctly for each of the conditions, according to the previews of the formats. However, regardless of the value in the cell (the error message of #VALUE!, Ok, or Late!), that value is in white font. Any ideas? I'm not sure if the problem is the order of my conditions (I've switched them but it doesn't seem to help) or my using Cell Value Is instead of Formula Is. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting qn
Hi Mat,
I have a similar problem as yours. I have cells A which calculate a value. The conditionally formatted cells B have conditions based on the values calculated in Cells A. Cells B are linked to another sheet. However, the colors are not changing. I think it is because the calculations in Cells A are happening at the same time as the cells in group B are being filled. Can you please let me know how you solved your problem? Thanks, Trisna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Function Troubleshooting | Excel Worksheet Functions | |||
Troubleshooting Spreadsheets | Excel Discussion (Misc queries) | |||
troubleshooting | Setting up and Configuration of Excel | |||
Template troubleshooting... | Setting up and Configuration of Excel |