Strike out cell if condition is met
sebdd87
Posted messages
5
Status
Membre
-
Elie_1702 Posted messages 2 Status Membre -
Elie_1702 Posted messages 2 Status Membre -
Hello everyone,
I would like that in my Excel table when I add a date in a column, the part of that row where the amounts are located appears crossed out.
I think I'll use the IF function to do this, but I don't know how to make the selected cells appear crossed out.
Thank you in advance.
I would like that in my Excel table when I add a date in a column, the part of that row where the amounts are located appears crossed out.
I think I'll use the IF function to do this, but I don't know how to make the selected cells appear crossed out.
Thank you in advance.
1 réponse
Hello
Excel does not handle the possibility of strikethrough cells in conditional formatting, but you can shade them or change the color
example to adapt
Rows 2 to 100 filled from A to F, with dates in column G. G and empty before entering a date with the keyboard
select A2;G100
ribbon / home tab / Conditional Formatting icon and "new rule"
in the "use a formula..." window
enter the formula:
=$G2>0
click on format, format with for example under "fill style" and shading
be careful of the $ sign in front of G1 to shade the entire row
Best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
Excel does not handle the possibility of strikethrough cells in conditional formatting, but you can shade them or change the color
example to adapt
Rows 2 to 100 filled from A to F, with dates in column G. G and empty before entering a date with the keyboard
select A2;G100
ribbon / home tab / Conditional Formatting icon and "new rule"
in the "use a formula..." window
enter the formula:
=$G2>0
click on format, format with for example under "fill style" and shading
be careful of the $ sign in front of G1 to shade the entire row
Best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
Elie_1702
Posted messages
2
Status
Membre
Thank you so much, Sir!!!