![]() |
Conditional formatting based on numerical values of adjacent cells
I am working on a form where cell A1 is text and I would like to use
conditional formatting to highlight A1, when B1 (number) is greater than zero. I have not been able to figure this out and I would appreciate any assistance. -- Rardel K |
Conditional formatting based on numerical values of adjacent cells
Use CF in A1 with a formula of =B10
-- __________________________________ HTH Bob "Rardel K" wrote in message ... I am working on a form where cell A1 is text and I would like to use conditional formatting to highlight A1, when B1 (number) is greater than zero. I have not been able to figure this out and I would appreciate any assistance. -- Rardel |
Conditional formatting based on numerical values of adjacent c
Thank you so much.
-- Rardel K "Bob Phillips" wrote: Use CF in A1 with a formula of =B10 -- __________________________________ HTH Bob "Rardel K" wrote in message ... I am working on a form where cell A1 is text and I would like to use conditional formatting to highlight A1, when B1 (number) is greater than zero. I have not been able to figure this out and I would appreciate any assistance. -- Rardel |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com