Conditional formatting for a group of cells

Billvh

New Member
Joined
Oct 28, 2014
Messages
17
I have a question on conditional formatting that I was hoping I could get some help with.

I have three columns.

Column A is the amount due

Column B is the due date

Column C is the date that the amount was paid

I would like to set conditional formatting to do the following:

  • If all of the cells #1, #2 and #3 all have text/numbers in them I would like to:
    • Have the text switch from black to dark gray color

Thanks for your help.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
 

Billvh

New Member
Joined
Oct 28, 2014
Messages
17
Thanks for the help.

I worded the question wrong.

When cells A1, B1 and C1 all have numbers in them. How do I conditional format to change the text color?
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
ISNUMBER(A1) and so on

Book1
ABCD
1234aa
2bb5ww
Sheet7
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A1:D2Expression=ISNUMBER(A1)textNO
 
Last edited:

Billvh

New Member
Joined
Oct 28, 2014
Messages
17

ADVERTISEMENT

Thanks for your help.


I put the above conditional formatting
  • =ISNUMBER(M4)

to apply to these cells
  • =$K$4:$M$4

but, the only cell that formats is K4

Can you tell what I'm doing wrong?


Thanks again,
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
try ISNUMBER(K4) - the first cell of the range not the last

I still recommend to read all from link in post#2
 

Billvh

New Member
Joined
Oct 28, 2014
Messages
17

ADVERTISEMENT

try ISNUMBER(K4) - the first cell of the range not the last

I still recommend to read all from link in post#2
I will read it, thanks for the information.

K4 doesn't work because I need it to stay black and then when M4 is filled in I need K4, L4 and M4 to turn gray at that point.

Does that makes sense?
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
use XL2BB to post your representative example and expected result also detailed description what you want to achieve

You didn't say that in your posts
I need it to stay black and then when M4 is filled in I need K4, L4 and M4 to turn gray at that point.
 

Billvh

New Member
Joined
Oct 28, 2014
Messages
17
I had some issues adding XL2BB and I have meet family soon so I will add it in later this afternoon.

Here is what I'm trying to do. It seems simple enough, but I'm missing it. This is just a budget spreadsheet.
Each item is three cells, amount do, due date and paid date. I just want the three cell block to turn gray after
the paid date cell is populated.


1610292371387.png
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
before
Book1
KLM
412
Sheet8
Cells with Conditional Formatting
CellConditionCell FormatStop If True
K4:M4Expression=ISNUMBER($M4)textNO

after
Book1
KLM
4123
Sheet8
Cells with Conditional Formatting
CellConditionCell FormatStop If True
K4:M4Expression=ISNUMBER($M4)textNO
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,122,850
Messages
5,598,455
Members
414,239
Latest member
xnanx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top