|
Conditional Formula
i am trying to highlight the entire row say if column H has a value greater than 1200. but column H has a formula and gets the input from another sheet.
thanks EggHeadCafe - Software Developer Portal of Choice ASP.NET Asynchronous Page Processing http://www.eggheadcafe.com/tutorials...nous-page.aspx |
Conditional Formula
Use CF/ Formula Is/ =$H21200 (assuming that it's row 2 that is selected).
Note that you've got absolute addressing for the column, and relative for the row. -- David Biddulph <MOHAMMED TAIZUM wrote in message ... i am trying to highlight the entire row say if column H has a value greater than 1200. but column H has a formula and gets the input from another sheet. thanks EggHeadCafe - Software Developer Portal of Choice ASP.NET Asynchronous Page Processing http://www.eggheadcafe.com/tutorials...nous-page.aspx |
| All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com