Cell color based on cell value as compared to another cell va

		Microsoft Office Forums > Microsoft Excel > Excel
Cell color based on cell value as compared to another cell va

FAQ

Thread Tools

Display Modes

09-25-2018, 04:09 AM

jeffreybrown jeffreybrown is offline

Windows Vista Cell color based on cell value as compared to another cell va

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Quote:

Originally Posted by ArviLaanemets

Conditional formatting doesn't recognize Tables, and it doesn't work with named ranges either.

You might want to check the part about CF not working with named ranges.

I defined a block of 3 numbers and assigned the named range MyNumbers to it. In those cells I typed in 1, 1, and 1.

As an example, I used in CF >> =SUM(MyNumbers)=3

Works okay for me.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
looking to change cell color by typing number into the cell	ibs	Word Tables	1	11-22-2016 06:31 PM
Entering a number in a cell causes it to fill with the color of a nearby cell	Bill Martz	Excel	1	04-23-2015 07:57 PM
Cell Background Color: Base it on Content of Cell?	tatihulot	Excel	4	08-14-2013 03:24 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:43 AM.