Conditional Formatting - change cell colour and and adding text

mattbarb

New Member
Joined
Mar 22, 2018
Messages
41
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px}</style>Hi,


Im trying to use condition formatting to change the cell colour and add some text to the cell. The formula I’m using is =$K$11<$K$10 I’ve tried something like IF=($K$11<$K$10,A1=“Red”) but can’t get it to work. Help would be most appreciated.


Thanks,


Matt
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

aqeelnokia99

Board Regular
Joined
Dec 23, 2018
Messages
65
in conditnal formating work based on True and Fales or 0 And 1 u can use
like =AND($K$11<$K$10,$A1="Red")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
58,139
Office Version
  1. 365
Platform
  1. Windows
Conditional formatting cannot put text in a cell, but in some instances it can format a cell to show a certain text value.
What is in the cell you want the CF to work on?
 

mattbarb

New Member
Joined
Mar 22, 2018
Messages
41
Hi,
I’d like to change the coloured red of a cell to red if one cell is greater then another and add the word ‘red’ to the cell. Many thanks Matt
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
58,139
Office Version
  1. 365
Platform
  1. Windows
Could you please answer my question?
Also this
I’d like to change the coloured red of a cell to red
makes absolutely no sense to me I'm afraid.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,646
Messages
5,654,567
Members
418,142
Latest member
peterappiahkubi

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