Creating a conditional format useing an IF statement

[THKUCOMEAGAIN]

ok i i am working on my school final exam and i need to make a conditional format useing an if statement that allows the cells that need information to be typed into to be highlighted but i want to keep it clean so i dont want a half of page of highlighted cells.

Is there an IF statement that will trigger the conditional formating when the last cell (that needs information typed in it) has the information typed in it

 

[T. Valko]

ok i i am working on my school final exam and i need to make a conditional format useing an if statement that allows the cells that need information to be typed into to be highlighted but i want to keep it clean so i dont want a half of page of highlighted cells.

Is there an IF statement that will trigger the conditional formating when the last cell (that needs information typed in it) has the information typed in it

Assuming cell A1 is that last cell...

=$A$1<>""

 

[THKUCOMEAGAIN]

cell G5 would be the one triggering the conditional formating so do i just replace A1 with G5?

 

[T. Valko]

cell G5 would be the one triggering the conditional formating so do i just replace A1 with G5?

Yes:

=$G$5<>""

Which means: G5 is not equal to blank

 

[THKUCOMEAGAIN]

ok but how do i get that to trigger on the next line then if it is absolute?

And also i was going to use this trigger for more than one cell

 

[THKUCOMEAGAIN]

do i just change G5 to the next corresponding cell i want to trigger it?

 

[T. Valko]

ok but how do i get that to trigger on the next line then if it is absolute?

And also i was going to use this trigger for more than one cell

Need a more detailed explanation of what cells you want to format.

It sounds like you want to format cells on each row if a certain cell on that row contains an entry?

What version of Excel are you using?

 

[THKUCOMEAGAIN]

Need a more detailed explanation of what cells you want to format.

It sounds like you want to format cells on each row if a certain cell on that row contains an entry?

What version of Excel are you using?

2010 and yes i have a sheet that i need users to put in information in the unlocked cells and i want a trigger to highlight the next line of required cells the user has to put in formation in. Once the user puts the last information in in column G (the first cell they are required to put in is G5)

My sheet goes from columns A-I

A,B,C,D,F,G are all required for the user to input info (row 5 is where they actualy start inputing the info)

Columns E,H,I are all calculated with this info they enter