ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional formatting based on numerical values of adjacent cells (https://www.excelbanter.com/excel-programming/425381-conditional-formatting-based-numerical-values-adjacent-cells.html)

Rardel K

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

Bob Phillips[_3_]

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




Rardel K

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