Excel conditional formatting?

Question

My data has two columns, sale date and list date, and I need to use conditional formatting to highlight which sale dates are lower than the listed dates. How do I do this?!

Answer 1

Column A is your sale date and column B is your list date

• Select all the dates in column A

• Go to conditional formatting

• In the Conditional Formatting dialog box, choose for the first drop-down box CELL VALUE IS

• In the second drop-down box, choose one of the operators. In your case, choose "less than"

• In the next box, type the cell reference "=$B1" (without the quotes)

• Choose the format/highlight you wish to use

• Click the OK button



That's all

Answer 2

Select the data. Then go to the Format menu, and choose Conditional Formatting. For condition 1, use the drop down box to the right of Cell Value Is and change to "less than", then for the next box on the right, click the little symbol of a red arrow in a square. This collapses the Conditional Formatting menu. Click on the date you want to compare it to, then click the red arrow symbol again to return to the CF menu. Then click Format and choose a different colour to display when that condition is true.



Then click Add on the bottom line, and you can set up a Condition 2.

Answer 3

assuming your sales dates start in A1 and list dates start in B1

select the dates in column A

go to conditional formatting

pick "Formula is"

enter =$B1<$A1

choose the way you want the formatting to change and "Ok"



hope this helps

Answer 4

decide on cellular B1 and set the conditional format to 'formulation equals': IF(A1="gas",actual,fake) and IF(A1="grocery",actual,fake) with the shading as you like (it somewhat is somewhat what you probably did). Then come out of conditional formatting and with cellular B1 nevertheless chosen, click on the format painter button (paintbrush icon on the toolbar). this might reproduction each and every of the formatting in B1. Then higlight the the rest cells in column B the place you like the formulation to be copied to, this immediately pastes the conditional format to the different cells in column B and could replace the cellular references which you somewhat want.