How to Make a Cell Turn a Color in a Formula in Excel : Using Microsoft Excel

Toggle fullscreen Fullscreen button

Sharing buttons:

hi I'm Ted today I'm going to show you

how to make cells turn color in a

formula in Excel what we're talking

about here is something called

conditional formatting it's a way of

having the format of a cell the color or

other features of the cell change

depending on the value that's in the

cell so let's take a look at this

spreadsheet I have setup here it's just

a fictional list of pay for different

employees and what we're going to do is

we're going to select the cells that we

want to be conditionally formatted so

I'm going to select that the total pay

here in in column D just the values not

the total at the bottom and then you're

going to look for a menu item it'll be

under the format menu and it may look a

little different depending on your

computer and your operating system and