|
conditional format
I'm having an issue getting my condtional format to read negative numbers.
The format is if the reference cell is less then 100 fill the box red. The reference cell is a lookup value. The conditional format works for everything including zero but once you hit -1 it goes back to green (a different conditional format for 100) |
conditional format
What are your CF conditions, and in what order?
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" <Conditional wrote in message ... I'm having an issue getting my condtional format to read negative numbers. The format is if the reference cell is less then 100 fill the box red. The reference cell is a lookup value. The conditional format works for everything including zero but once you hit -1 it goes back to green (a different conditional format for 100) |
conditional format
j12200 shade green
j12=100 shade yellow j12<100 shade red "Bob Phillips" wrote: What are your CF conditions, and in what order? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" <Conditional wrote in message ... I'm having an issue getting my condtional format to read negative numbers. The format is if the reference cell is less then 100 fill the box red. The reference cell is a lookup value. The conditional format works for everything including zero but once you hit -1 it goes back to green (a different conditional format for 100) |
conditional format
That looks fine, what is the formula in J12.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" wrote in message ... j12200 shade green j12=100 shade yellow j12<100 shade red "Bob Phillips" wrote: What are your CF conditions, and in what order? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" <Conditional wrote in message ... I'm having an issue getting my condtional format to read negative numbers. The format is if the reference cell is less then 100 fill the box red. The reference cell is a lookup value. The conditional format works for everything including zero but once you hit -1 it goes back to green (a different conditional format for 100) |
conditional format
=Wafer_Count!H6 where Wafer_Count is a different tab in the WB
H6 on that tab is: ='\\f17epdr1\Area_Reports\C4\MRC_Status\[MRC_Status.xls]Wafer_Count'!H6 If i actually type in a negative number it recongizes that it is less then 100 but the lookup value gives it a hard time. "Bob Phillips" wrote: That looks fine, what is the formula in J12. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" wrote in message ... j12200 shade green j12=100 shade yellow j12<100 shade red "Bob Phillips" wrote: What are your CF conditions, and in what order? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" <Conditional wrote in message ... I'm having an issue getting my condtional format to read negative numbers. The format is if the reference cell is less then 100 fill the box red. The reference cell is a lookup value. The conditional format works for everything including zero but once you hit -1 it goes back to green (a different conditional format for 100) |
conditional format
Try this formula in the CF
=--J12<100 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" wrote in message ... =Wafer_Count!H6 where Wafer_Count is a different tab in the WB H6 on that tab is: ='\\f17epdr1\Area_Reports\C4\MRC_Status\[MRC_Status.xls]Wafer_Count'!H6 If i actually type in a negative number it recongizes that it is less then 100 but the lookup value gives it a hard time. "Bob Phillips" wrote: That looks fine, what is the formula in J12. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" wrote in message ... j12200 shade green j12=100 shade yellow j12<100 shade red "Bob Phillips" wrote: What are your CF conditions, and in what order? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Conditional Formats" <Conditional wrote in message ... I'm having an issue getting my condtional format to read negative numbers. The format is if the reference cell is less then 100 fill the box red. The reference cell is a lookup value. The conditional format works for everything including zero but once you hit -1 it goes back to green (a different conditional format for 100) |
| All times are GMT +1. The time now is 02:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com